topic Re: SamePeriodLastYear in DAX Commands and Tips

SamePeriodLastYear

Anonymous — Thu, 28 Apr 2022 01:05:20 GMT

Hello,

I have a measure -- Net_Sales_SPLY = Calcuate(Sum('Table'[SalesAmt]), SAMEPERIODLASTYEAR('CalendarTable'[Date]))

and get the following error every so often.

Not able to fully understand the error message or solve the issue.

I have also tried DateAdd -1 Year - but not able to solve the problem.

Will greatly appreciate some input.

Many thanks,

Pavan

Re: SamePeriodLastYear

amitchandak — Thu, 28 Apr 2022 01:16:28 GMT

Anonymous , You seem to have bidirectional join with with date table, make that single directional.

Also make sure calendar table is marked as date table

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4

Re: SamePeriodLastYear

tamerj1 — Thu, 28 Apr 2022 01:21:43 GMT

Hi Anonymous

you may try

Net_Sales_SPLY = CALCULATE ( SUM ( 'Table'[SalesAmt] ), SAMEPERIODLASTYEAR ( 'CalendarTable'[Date] ), CROSSFILTER ( 'Table'[Date], 'CalendarTable'[Date], 3 ) )

Re: SamePeriodLastYear

Anonymous — Thu, 28 Apr 2022 02:20:57 GMT

Thanks tamerj1.

It is not breaking any more, but the numbers don't seem right.

I should have mentioned earlier that the date in the Table[Sales Amt] is a week ending date, and the date in the Calendar table is a daily date. Not sure if this matters or not.

Thanks again!

Re: SamePeriodLastYear

Anonymous — Thu, 28 Apr 2022 02:21:37 GMT

Thanks amitchandak.

It is not breaking any more, but the numbers don't seem right.

I should have mentioned earlier that the date in the Table[Sales Amt] is a week ending date, and the date in the Calendar table is a daily date. Not sure if this matters or not.

Thanks again!

Re: SamePeriodLastYear

tamerj1 — Thu, 28 Apr 2022 02:25:48 GMT

Hi Anonymous
Would you please share a screenshot of your table visual?

Re: SamePeriodLastYear

Anonymous — Thu, 28 Apr 2022 02:29:49 GMT

Re: SamePeriodLastYear

tamerj1 — Thu, 28 Apr 2022 02:38:31 GMT

Anonymous
Sorry I mean the report visual. Can you share the results you are getting? What are you slicing by in your report? The Date column from the calendar table or from the sales table?

Re: SamePeriodLastYear

amitchandak — Thu, 28 Apr 2022 03:21:13 GMT

Anonymous , the Same week can fall in a different month. Unless you have 445 calendar. But based on weekend date falling in month total should be correct