Forum Discussion

Anmolgan's avatar
Anmolgan
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Year Over Calculation/Same Period Last Year Coming Wrong?

Hi, I am looking to calculate Same Period Last Year calculations, I have dataset for atleast 3 years, now I want the sales to work year wise, month wise and Date range wise (All should give a compari...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    6 years ago

    As discussed

    Last Year Sales = CALCULATE([Total Sales Sumx],DATEADD('Date'[Date], -1,YEAR))
 
This Year Sales = CALCULATE([Total Sales Sumx],DATEADD('Date'[Date], 0, year))
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

As discussed

Last Year Sales = CALCULATE([Total Sales Sumx],DATEADD('Date'[Date], -1,YEAR))
 
This Year Sales = CALCULATE([Total Sales Sumx],DATEADD('Date'[Date], 0, year))
  • Anmolgan's avatar
    Anmolgan
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    amitchandak thanks for your end to end support on the issue. Much appreciated!!