Help with SamePeriodLastYear

[VRGood]

Excel 2010
64 Bit
PowerPivot AddIn

Hello all,

I'm having to make modifications to a PowerPivot Table due to change in data structure.

I have succeeded in creating the new measure called "NewSales" below:

=Calculate('Tkt Sales Tbl'[Sum of SAL_SUB_TOT 2])-('PSTktLinTbl'[Sum of Ext_Prc])

I now need to use this measure in a calculation for SamePeriodLastYear. I have tried unsuccessfully to simply change the field name in the formula below but keep getting an the error message "Column 'NewSales' in table 'Tkt Sales Tbl' cannot be found or may not be used in this expression". I have also tried using [Sum of NewSales] in the formula.

=CALCULATE(sum('Tkt Sales Tbl'[SAL_SUB_TOT]),SamePeriodLastYear('DtTbl'[Date]))

Any help would be greatly appreciated.

Thank you,
Valerie

 

[VRGood]

I resolved this issue. I am posting the formula below in case this might be of help to someone with a similar problem.

=CALCULATE(sum('Tkt Sales Tbl'[SAL_SUB_TOT])-PSTktLinTbl[Sum of EXT_PRC],SAMEPERIODLASTYEAR(DatesMTD(DtTbl[Date])))

Valerie

 

[elliotstan]

You can see some further info on one of Kasper De Jonge's posts
Kasper de Jonge PowerPivot and Power BI Blog | Get the YTD of same period last year using DAX

Thanks for posting the solution though.