Forum Discussion
Solved
Calculate Average for a measure
I have a table that looks something like this: I use the following formula to caluculate the MEASURE 'Alternative Claculated Burn Rate': Alternative Calculated Burn Rate = DIVIDE([Cou...
Hi yashrajs
You can consider to create a date table, then create one-many relationship between tables
Then use the following measure.
Measure = CALCULATE ( AVERAGE ( 'Historical Contracts by Load Date'[Alternative Calculated Burn Rate] ), DATESINPERIOD ( 'DateTable'[Date], MAX ( 'DateTable'[Date] ), -6, MONTH ) )and you can refer to the following link about the function.
DATESINPERIOD function (DAX) - DAX | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi yashrajs
Try the following measure.
Alternative Burn Rate MA =
CALCULATE (
DIVIDE (
SUMX (
TOPN (
6,
ALLSELECTED ( 'Historical Contracts by Load Date' ),
'Historical Contracts by Load Date'[Start of Month Date], DESC
),
[Alternative Calculated Burn Rate]
),
6
)
)
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the suggestion Anonymous however this doesn't seem to work correctly. It gives an insanely high value.