Forum Discussion
Error - Calculate + sameperiodlastyear
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
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.
4 Replies
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-Forum/ba-p/963216
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/1447523Thank 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
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
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.
Hi There,
You are a super star, thank you.
