Forum Discussion

GoingIncognito's avatar
GoingIncognito
Advocate 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
Solution Sage
6 years ago

Hi GoingIncognito ,

Is "balance" a measure or a field? It seems that the writing of sum(balance) is wrong. Other than that, your formula doesn't seem to be wrong. Could you share your sample data?

I created a demo like the following, you can see if there is any difference with your data.

 

Here is the demo, please try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EdT57djaTiJHqroo648lPwIBO71aT7rxtkeD0upIgvSZmg?e=jybxsx

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
    Advocate III
    6 years ago

    Thank you for your reply!

     

    Balance is a field. There is only one balance for each month.

      • GoingIncognito's avatar
        GoingIncognito
        Advocate III
        6 years ago

        I am still at loss, what am I doing wrong?

         

        Picture above includes the date from fact table, date from calendar table, and following measures

         

        Measure1 = SUM('fact table'[balance])

        Measure2 = calculate([Measure1], dateadd('calendar'[date], -1, month)

        MoM = [Measure1] - [Measure2]