Forum Discussion

BugmanJ's avatar
BugmanJ
Icon for Helper V rankHelper 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
BugmanJ's avatar
BugmanJ
Icon for Helper V rankHelper V
1 year ago

Hi,

Wow this is great, but I have a slight nuance, If i wanted to display just the month, it gives me "0.00". 

How can I fix this so that it shows me for that date?

E.g. Lets say we are on the 7th of Jan, so the value would show: Jan 0.98????

Thank you


Anonymous's avatar
Anonymous
Not applicable
1 year ago

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

  • BugmanJ's avatar
    BugmanJ
    Icon for Helper V rankHelper V
    1 year ago

    Thank you for sticking with this. However reducing it down to a single month or even months doesnt work.