Forum Discussion
Return single date
Hello, Sorry I'm new to Power BI. But within a measure I'm looking for return just single date. But this date needs to be the newest day minus 3. For example: last date on the dataset 20/03/2...
Hi Anonymous ,
You can use the ALL function to remove all filters and return a single date.
Measure = CALCULATE(MAX('Calendar'[Date])-3,ALL('Calendar'))Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , A measure or measure var
maxx(ALLSELECTED('Calendar'),'Calendar'[Date]) -3