Error - Calculate + sameperiodlastyear

[Onclevini]

Hi there,

Can you please help me with the issue I'm facing. I'm using 2 mesures, one for the sales and the sales last year. I used Calculate + Sameperiodlastyear. For some reasons my table is blank except the total.

Year        Sales      Sales LY
2020         473
2021         802
2022        1874
2023        1757
TOTAL      4906        3149

Does anyone has a solution for me? Thank you

#Sameperiodlastyear

[Onclevini]

Thank you for your answer and sorry for my late reply, I just came back from leave. 

Hereunder you will find the data I'm using

https://we.tl/t-cXXvIrOr6F

This is what I've got so far

Year	Sales	Sales LY
2020	473
2021	802
2022	1874
2023	1757
TOTAL	4906

And this is what I'm expecting

Year	Sales	Sales LY
2020	473
2021	802	473
2022	1874	802
2023	1757	1874
TOTAL	4906	3149

Thank you for your help

[lbendlin · Accepted solution]

Attached is the basic framework.  

- modify your source data to include a date column

- add a Dates table to your data model

- create the SPLY measure from the Dates date column.

Note that this will not be useful for "Period To Date"  reports. To account for partial periods you need to do additional work.

[Onclevini]

Hi There,

You are a super star, thank you.

[lbendlin]

Time Intelligence DAX functions require the use of a contiguous and covering calendar table.

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...