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.

Thejeswar's avatar
Thejeswar
Super User
5 years ago

Hi nmhung49 ,

Change the SPLY formula as follows. Also I am not really sure, why you need a separte Date Dimension Table for this functionality. Change the formula to use Date from the same table as given below

 

SPLY = CALCULATE(SUM(Data[Sale]),SAMEPERIODLASTYEAR(Data[Date]))
 
This will change the Output from 98 to 13.
 
Why do you expect to see 11..which the Sales for Same period last year is 13
PFB screengrab

 

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