Reply
Highlighted
Visitor
Posts: 1
Registered: ‎10-16-2018

Current year vs Previous year line chart failure

Hello,
When I try to make a line chart of the previous and current year using the meassure 

Previous year Amount = CALCULATE([Amount], DATEADD('CalendarDay'[Date],-12,MONTH))

 

(Current year) Amount - (SUM('Table'[Price]))

 

I get ithe same data as for the current year, if I apply the measure

 

Previous year Amount =CALCULATE([Amount],ALL('Table1'[Year]), DATEADD('CalendarDay'[Date],-12,MONTH)) 

it shows me the sum of all the previous years.

 

Any idea why? PS. im using Directquery mode