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.

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

ryan_mayu amitchandak 

Sorry It is show 13, I separte DimDate Table because this is the primary key table that is related to other tables I use this table to control year, month, day

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

nmhung49 

Pls try this

SPLY = 
VAR _MAX=MAX('Table'[Date])
RETURN CALCULATE(SUM('Table'[Sale]),FILTER(ALL('Table'),YEAR('Table'[Date])=YEAR(_MAX)-1&&MONTH('Table'[Date])<=MONTH(_MAX)))

pls see the attachment below