Forum Discussion

nmhung49's avatar
nmhung49
Helper 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.

ryan_mayu's avatar
ryan_mayu
Super User
5 years ago

nmhung49 

why last year is 11? from jan to May is 13. 

  • nmhung49's avatar
    nmhung49
    Helper II
    5 years ago

    I'm sorry show 13 not 11, I want to Card 1 st show 30 and Card 2nd show 13 with (Picture #1) because Actual Data have Date 01/01/2020 to 31/05/2021 but DimDate have Date 01/01/2020 to 31/12/2021

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      5 years ago

      nmhung49 

      pls try this

      Measure = 
VAR _max=max('Table'[Date])
return sumx(FILTER('Table','Table'[Date]=_max),'Table'[sales])