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.
Hi
Firstly, I've only just starting using Power BI so am by no means an expert.
I'm working with an existing document that contains a particular measure:
Cumulative forecasts in future = CALCULATE(SUM('Forecast Report Oct 2016'[Forecast amount]),FILTER(ALL('Calendar'[Date]),AND('Calendar'[Date]>TODAY(),'Calendar'[Date]<=MAX('Calendar'[Date]))))
When i refresh this data now (in October) the forecasts for October do not appear, i'm assuming because of the >TODAY part of the measure.
Can anyone please provide a suggested update to this measure, perhaps changing the >TODAY to something about the end of the previous month so that the October forecasts are show?
Thank you!
How about something like:
For today, that should return 10/1/2018 in the filter
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 |
---|---|
114 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |