cancel
Showing results for
Did you mean:

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

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
Resolver I

Hi @Natasha93 ,

Try below:

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

3 REPLIES 3
Resolver I

Hi @Natasha93 ,

Tickets Last Year = CALCULATE(
)
If this helps you then please mark it as a solution and hit the thumbs up. Thanks.
Frequent Visitor

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

Resolver I

Hi @Natasha93 ,

Try below:

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

Announcements

#### New forum boards available in Real-Time Intelligence.

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

#### Power BI Monthly Update - May 2024

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

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors