Forum Discussion

danmone's avatar
danmone
Frequent Visitor
6 years ago
Solved

Sameperiodlast year returning same figures as current year

Hi

 

I'm trying to create a sales report that shows current sales in one column and the previous years figures for the same period.  I'm using the following DAX 

Total Sales PY = CALCULATE(SUM('Live Company$G_L Entry'[PositiveAmount]), SAMEPERIODLASTYEAR('Invoked Function'[Date].[Date]))
 
however it returns the same data in both fileds in the table.  where am I going wrong?
 
Thanks

2 Replies