Forum Discussion
BugmanJ
Helper V
Helper VCalculate current order level versus previous months average
Hi, If we have the following data: Date Ordes that Day Running Total 01/05/2024 6 6 02/05/2024 6 12 03/05/2024 6 18 04/05/2024 6 24 05/05/2024 6 30 And so...
Hi BugmanJ ,
Try this
Measure =
VAR _monthname = SELECTEDVALUE(DateTable[Month Name Short])
VAR _result = FORMAT(DIVIDE([Running Total],[previousTotalAverage],0),"0.00")
RETURN
_monthname & " " & _result
Best Regards
BugmanJHelper V
Helper VThank you for sticking with this. However reducing it down to a single month or even months doesnt work.