PowerBI: SAMEPERIODLASTYEAR function not working

Question

I am getting a error when I write the following code

LYSales = CALCULATE([Total Sales],SAMEPERIODLASTYEAR('Date'[Date]))

 

Answer 1

Use the following measure:

-- This reference a Measure, which in your case is not defined
LYSales = CALCULATE([Total Sales],SAMEPERIODLASTYEAR('Date'[Date]))
-- you can create it with this formula
Total Sales = SUM('_TableName_'[Total Sales])

--The other way is to use only one formula
LYSales = CALCULATE(SUM('_TableName_'[Total Sales]),SAMEPERIODLASTYEAR('Date'[Date]))

If u want to learn the tool in-depth, then come to us and sign up for this Power BI Certification