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,
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/2021 and I want it to return 17/03/2021.
This is what I've tried so far but it returns multiple dates:
Solved! Go to Solution.
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.
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 Hey Bruh ,
You can take inspriration from my calculation .
@Anonymous , A measure or measure var
maxx(ALLSELECTED('Calendar'),'Calendar'[Date]) -3
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |