Alternate approach for sameperiod last year when dates are not continuous

[puneethjp]

Hi ,

I have the following requirement ,  I need to calculate same period last year for sales , but i have only week ending date in my table , and if i use sameperiod last year, it thows error as sameperiod last year expects a continuous dates, Is there any other alternate for this scenario to use weekending date in sameperiod last year.

[parry2k]

@puneethjp 

As a best practice, add a date dimension in your model and use it for time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools. Check the related videos on my YT channel

Add Date Dimension
Importance of Date Dimension
Time Intelligence Playlist