Conditional formatting based on Row security level?

[Max]

Hi @remba87

You would set up dynamic defaults.

How to create a dynamic default value for a control

First of all, you’ll have to change the field to a date field. If you leave it as a string, QuickSight can’t determine the max. If you have issues with the date format, we can address that separately. I see you’re using MM/dd/yyyy - that should not be a problem in QuickSight. Then create a copy of the dataset and use it to calculate the max value at the dataset level, e.g. by using SQL if your data source is a database. You also need to include a column that contains every reader’s UserName…