Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |