SAMEPERIODLAST YEAR + One Day

[Anonymous]

Hi all 🙂

I am using SAMEPERIODLASTYEAR to determine the number of tickets created to help forecast for upcoming dates.

For example, Monday 12th September 2022 is a Public Holiday in Switzerland. 

12th September 2021 was a Sunday, and as it fell on a weekend the number of tickets would be drasitcally different anyway.

So I'm looking to compare to Monday 13th September 2021.

How can I adjust my measure for SAMEPERIODLASTYEAR to add an extra day?

Tickets Last Year = CALCULATE(

                        [TICKET_COUNT],SAMEPERIODLASTYEAR('Calendar'[Date])

                        )

[keshavagrawal27]

Hi @Anonymous ,

Please find below the Solution to your question.

Tickets Last Year = CALCULATE(

                        [TICKET_COUNT],SAMEPERIODLASTYEAR('DateAdd(('Calendar'[Date],1))

                        )

If this helps you then please mark it as a solution and hit the thumbs up. Thanks.

[Anonymous]

Hi @keshavagrawal27 
Thanks for the quick response!

I copied it exactly and Power BI didn't like it...
"Too many arguments were passed to the SAMEPERIODLASTYEAR function. The maximum argument count for the function is 1."

[keshavagrawal27 · Accepted solution]

Hi @Anonymous ,

Try below:

Tickets Last Year = CALCULATE(           [TICKET_COUNT],SAMEPERIODLASTYEAR('DateAdd(('Calendar'[Date],1,Day)))