Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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" ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
96 | |
75 | |
71 | |
64 |
User | Count |
---|---|
140 | |
109 | |
103 | |
82 | |
73 |