Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Natasha93
Frequent Visitor

SAMEPERIODLAST YEAR + One Day

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])
                        )
1 ACCEPTED SOLUTION

Hi @Natasha93 ,

Try below:

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

 

View solution in original post

3 REPLIES 3
keshavagrawal27
Resolver I
Resolver I

Hi @Natasha93 ,

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.

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."

Hi @Natasha93 ,

Try below:

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

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors