Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello people.
I need some help calculating a running total based on a daily forecast.
So, here’s a screenshot of my model:
As Forecasts are calculated on a monthly basis, I can´t set a relation to the calendar table. So, my measures are as follows:
Total Forecast =
CALCULATE(
SUM(Forecast[Total Sales]),
TREATAS(VALUES('Calendar'[Month & Year]),Forecast[Month & Year]))
Hi @paliman ,
If you haven't resolved it and you still need help, can you please upload the sample file into OneDrive for Bussinees and share again with us? Now, I can't download it without access from your link.
@paliman , I think it would better if you create a daily forecast. and then use it.
Refer if this file :https://www.dropbox.com/s/fnq82ksdzk1lqs3/Target_allocation_daily.pbix?dl=0
Another option, do not split, check if that can work
https://www.youtube.com/watch?v=yPQ9UV37LOU
The reason it is not working, one measure is diving and distributing another one again aggregating that. Need to rework on the measures.
See any of the two approach can work.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |