03-20-2017 02:43 PM
We are trying to create a page level filter on the MAX(Date). By default the page level filters do not have the "Latest" filter like when you're creating a card visual. We have tried creating a MEASURE for the "Latest Date" and then creating a Calculated Column where if the DATE = Latest Date then it's true and if not false among many other suggestions from the web. It seems that since we are working in Direct Query mode, many of the suggestions do not work.
Latest Date = MAX([Date])
Is Latest = IF([Date] = [Latest Date], TRUE(), FALSE())
ERROR: Function 'MAX' is not allowed as part of calculated column DAX expressions on DirectQuery models.
Our data looks like the following and with the desired functionality we will only be looking at the BOLDED records.
|ID||Date||Miss Pg||Miss Vis||Clean||Locked||Signed|
03-20-2017 04:37 PM - edited 03-21-2017 07:37 AM
@parry2k, actually neither. "Latest" means the most recent date in the date column. It will not always be today and the records may not be in order so it can't be the "last" record. It should be equivalent to MAX() or LATEST() in terms of a datetime.