Forum Discussion
Applying a default last date on a filter
Hello,
i'm developing a report, that naturally does calculations over a so called "report date".
I would like that, when the report is opened without a "report date" selected in its slicer, it assumes the value of the last existing report date for that column, so my doubt also is about using MAX or LASTDATE.
Thanks in Advance.
Regards
Hi Anonymous ,
Based on my research, it is not supported yet currently. There is an idea about that you can vote it up to make this feature coming sooner.
BTW, We can create a calculated column as below to work around.
Column = VAR maxdate = MAXX ( 'Table', 'Table'[Date] ) RETURN IF ( [Date] = maxdate, "Last date", FORMAT ( 'Table'[Date], "yyyymmdd" ) )
1 Reply
v-frfei-msftCommunity Support
Hi Anonymous ,
Based on my research, it is not supported yet currently. There is an idea about that you can vote it up to make this feature coming sooner.
BTW, We can create a calculated column as below to work around.
Column = VAR maxdate = MAXX ( 'Table', 'Table'[Date] ) RETURN IF ( [Date] = maxdate, "Last date", FORMAT ( 'Table'[Date], "yyyymmdd" ) )