Forum Discussion

mmakhlo's avatar
mmakhlo
Frequent Visitor
9 years ago

Calculate difference from previous month

Hello!   I would like to display the difference in cost by month. This is the current table I have. It shows cost by year-moth by site. I would like to show the difference in cost each month in ano...
Need Help
mmakhlo's avatar
mmakhlo
Frequent Visitor
9 years ago

Hi GilbertQ

 

The date table was a great suggestion. It helped fix a few other issues I am having with the report. With regards to this post/calculation, when I create the measure for the cost of the previous month, it doesn't create a value.

 

Here is my equation

 

Ext Cost Previous Month = CALCULATE([Ext Cost Sum], PREVIOUSMONTH('Date'[Date]))

 

When I try to insert the number into a table nothing appears.

 

My value for the difference between months is the same as the current month which is another indication that the previous month calculation is not working properly.

 

Any suggestions?

GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi mmakhlo


Can you confirm that when creating your table or visual that you are using the Month from the DATE table you created and NOT from your data table?

 

That is often the issue when data is not showing, due to the PREVIOUSMONTH using the DATE table, and the table or visual is using the column from the data table, so the PREVIOUSMONTH will not work as expected.