Forum Discussion

Helper V

1 year ago

Calculate 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...

Need Help

Anonymous

Not applicable

1 year ago

Hi FarhanJeelani,thanks for the quick reply, I'll add more.

Hi BugmanJ ,

Try this

Measure = 
VAR _date = SELECTEDVALUE('Table'[Date])
VAR _day = DAY(SELECTEDVALUE('Table'[Date]))
VAR _total = AVERAGEX(FILTER(ALL('Table'),DAY([Date]) = _day && 'Table'[Date] < _date),[Running Total])
RETURN DIVIDE(MAX('Table'[Running Total]),_total)