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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.