Forum Discussion

nmhung49's avatar
nmhung49
Icon for Helper II rankHelper II
5 years ago
Solved

Caculate same period last year

I have Data table with date 01/01/2020 to 05/31/2021 and DimDate with date 01/01/2020 to 12/31/2021 When I create Dax Same Period Last Year for result 98 is incorrect. It is correct 13 Please help ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

nmhung49 , I check out total of year 2020 is 98. As you have seleced year, That will give you year total.

 

Also marked DimDate table as date table(option on right on table) and createcolumsn for Month, Yeat etc

 

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 :radacad sqlbi My Video Series Appreciate your Kudos.

  • nmhung49's avatar
    nmhung49
    Icon for Helper II rankHelper II
    5 years ago

    Thanks for you repply

    If slicer selected 2021 and Month not selected. I want Card Current Year show 30 and Card Same Period Last Year show 11

    Thanks