Need help with SAMEPERIODLASTYEAR, figures not showing

[Anonymous]

Hi, I am new to PowerBI and I've been trying to calculate the sales amount using SAMEPERIODLASTYEAR but it's not working. I have the monthly sales data from Jan 2020 to March 2021 and I also created a date table called 'Calendar' (marked this as date table as well). This is the formula I used to calculate the sales amount:

• Sales Last Year = CALCULATE([Sales Amount],SAMEPERIODLASTYEAR('Calendar'[Date]))

However, when I checked the results using matrix, I did not obtain any figures in the Sales Last Year Column for Jan 2021 to March 2021. Instead, I obtained figures for Jan 2020 to July 2020, which is obviously wrong. 

Can someone help me with this? Thank you!

[BA_Pete · Accepted solution]

Hi @Anonymous ,

Are you using calendar[Date] for the date column in your table visual? If not, you should.

*EDIT* Also, silly question, but have you related your calendar table to your fact table?

Pete

[Anonymous]

It works now! Thank you 🙂 

[BA_Pete]

@Anonymous ,

Cool, glad it's working for you now.

Please mark my answer as the solution to ensure that other people facing the same issue can find the answer quickly.

Ta,

Pete