Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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" ) )
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" ) )
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |