Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Parallelperiod issue

Hi all!    I'm trying to get the sales value of the previous previous month but i'm not been able to reach it using parallelperiod formula.    (CALCULATE(Consolidado[TO]; PARALLELPERIOD(Consolid...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Create a date dimension and try trailing period

CALCULATE(Consolidado[TO]; dateadd(Date[Date];-2;MONTH))

 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/