Forum Discussion
Previous month value
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]))
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]
4 Replies
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]
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?
Going to need to see some sample data to recreate, but I would go with GilbertQ suggestion of a date table.
