cancel
Showing results 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

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

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - June 2024

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

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors