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]); PREV...
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]
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]