topic Re: Error - Calculate + sameperiodlastyear in DAX Commands and Tips

Error - Calculate + sameperiodlastyear

Onclevini — Fri, 14 Jul 2023 05:46:02 GMT

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

Re: Error - Calculate + sameperiodlastyear

lbendlin — Sat, 15 Jul 2023 19:18:37 GMT

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/1447523

Re: Error - Calculate + sameperiodlastyear

Onclevini — Mon, 14 Aug 2023 09:28:42 GMT

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

Re: Error - Calculate + sameperiodlastyear

lbendlin — Tue, 15 Aug 2023 12:22:59 GMT

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.

Re: Error - Calculate + sameperiodlastyear

Onclevini — Tue, 15 Aug 2023 16:27:44 GMT

Hi There,

You are a super star, thank you.