Forum Discussion

Onclevini's avatar
Onclevini
Regular Visitor
3 years ago
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...
  • lbendlin's avatar
    lbendlin
    3 years ago

    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.

     

     

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

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