Forum Discussion

JoshSHardscape's avatar
JoshSHardscape
Helper I
8 years ago
Solved

Comparing Last Year Sales Values

Hi all,   Been working for the last day or so on producing some projection/tracking reports for sales. I've managed to get most rows of the matrix calculating what I want but am getting stuck when ...
Need Help
  • Floriankx's avatar
    Floriankx
    8 years ago

    Hello,

     

    please provide us the formula how you calculated SumLYLineValue.

     

    Did you use Sameperiodlastyear or DateAdd(DateTable;-1;Year)?

JoshSHardscape's avatar
JoshSHardscape
Helper I
8 years ago

Hi, thanks for the response.

 

This measure was calculated using the following:

SumLineValue = SUM('Sage Data'[Line Value])

SumLYLineValue = CALCULATE([SumLineValue],SAMEPERIODLASTYEAR('Sage Data'[Order Date].[Date]))

 

Would the DateAdd command be more appropriate or is it functionally identical?

 

Thanks,

Floriankx's avatar
Floriankx
Solution Sage
8 years ago

Hello,

 

the functions are similar.

DateAdd is great if you want to move back or forward day or months. In your case Sameperiodlastyear is great.

Do you have a contigous date table?

In such cases it's usually the best to have a separate date table which you relate to your date colum.

Then you calculate with Sameperiodlastyear(DateTable[Date]) and you put the Date data to your Pivot.

 

I'm not sure but this may cause your trouble.