Forum Discussion

GoingIncognito's avatar
GoingIncognito
Icon for Advocate III rankAdvocate III
6 years ago
Solved

Month over Month change

Hello, all you wise people. For some reason I've problem writing a measure that gives me MoM change. This should be an easy task. Sum(balance) gives me the total as it shoud, BUT when ever I inse...
Need Help
  • GoingIncognito's avatar
    GoingIncognito
    6 years ago

    I am sincerely thankful for your help!

    I think I finally solved this. For some reason the time intelligence didn't work - maybe there's a problem in the data, who knows - but I changed the [last_day_of_the_month] provided in the data to [first_day_of_the_month]. That worked.

v-joesh-msft's avatar
v-joesh-msft
Icon for Solution Sage rankSolution Sage
6 years ago

Hi GoingIncognito ,

Why do you want to use two date columns, try removing the “Fact date” column, or remove the "Calendar date" column and change Measure2:

Measure2 =
CALCULATE ( [Measure1], DATEADD ( 'fact table'[date], -1, MONTH ) )

 Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

GoingIncognito's avatar
GoingIncognito
Icon for Advocate III rankAdvocate III
6 years ago

I am sincerely thankful for your help!

I think I finally solved this. For some reason the time intelligence didn't work - maybe there's a problem in the data, who knows - but I changed the [last_day_of_the_month] provided in the data to [first_day_of_the_month]. That worked.