Previous month value

[Anonymous]

Hi!

I think I'm going crazy... I made this simple value to calculate the value of last month but the output is BLANK.... What's wrong?

CalcRevenuePrevious = CALCULATE(SUM('table'[Revenue]); PREVIOUSMONTH('table'[YearMonthDate]))

[Greg_Deckler]

Can't tell you what is wrong without sample data to recreate. But, note the description of PREVIOUSMONTH from the documentation:

Returns a table that contains a column of all dates from the previous month, based on the first date in the dates column, in the current context.

From:

https://msdn.microsoft.com/en-us/library/ee634758.aspx

So, the first question would be are you sure that the first date in that table in the current context is really the month you want?

[Anonymous]

PREVIOUSMONTH('table'[YearMonthDate]) alone returns the value I want. My table is aggregated on user-month level with the first date of that month in this column. 

Since this part of the formula works, I don't understand why the whole formula doesn't want to return a value. 

[Greg_Deckler]

Going to need to see some sample data to recreate, but I would go with @GilbertQ suggestion of a date table.

[GilbertQ · Accepted solution]

Hi @Anonymous

Do you have a Date Table in your Data model?

For the PREVIOUSMONTH measure to work, you would require having a date table for the Time Intelligence to work correctly.

Here is a link below to create a Date table, after which you can then create a relationship to your 'table'[YearMonthDate]

https://www.fourmoo.com/2016/09/13/power-bi-how-to-easily-create-dynamic-date-tabledimension-with-fiscal-attributes-using-power-query/