02-11-2019 06:07 AM
what's the error exactly? What's the syntax for [Total Sales]?
is the Date table marked as Date table, with Date[Date] as key column? see here https://docs.microsoft.com/en-us/power-bi/desktop-date-tables
is the join set to 1:many with single direction?
02-11-2019 09:10 AM
weird, syntax looks correct, but maybe you can try with this one:
LY Sales = CALCULATE ( [TotalSales], DATEADD ( 'Date'[Date], -1, YEAR ) )
I usually use https://www.daxformatter.com/ to verify syntax, maybe the spaces+capital letters will help
02-11-2019 09:41 PM
If the issue still occur, kindly share your pbix to me . Please upload your files to One Drive and share the link here.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.