Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I would like to have a measure that presents a rolling total of Actual Labour (in the past) AND Future Planned Labour.
We have a FactLabour table w/ actual labour and a m:1 relationship with DimDate
We have a FactPlannedLabour table /w planned labour and a m:1 relationship with DimDate
I would like to present in a line graph, with the date as the x axis, one line that shows rolling totals of actual labour amounts for days passed, and planned labour amounts for future dates.
I have measures to calculate the rolling total sum of actuals and planned based on date. I want these to be combined in essence:
So how can I calulate this? I tried the measure below, but I recognize it won't work as the planned portion will not sum the actual labour.
See if you can adapt the solution in the post below. It uses a blended measure that sums the two underlying measures, using Actual when available and Forecast for the remainder.
Proud to be a Super User!
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |