Forum Discussion
Solved
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 bla...
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.
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.