Forum Discussion
Month over Month change
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.
Thank you for your reply!
Balance is a field. There is only one balance for each month.
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]
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.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.
