Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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])
                        )
Need Help
Show and Tell
Tips and Tricks
  • keshavagrawal27's avatar
    keshavagrawal27
    4 years ago

    Hi Anonymous ,

    Try below:

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

     

3 Replies

  • keshavagrawal27's avatar
    keshavagrawal27
    Icon for Resolver I rankResolver I
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        keshavagrawal27
        Icon for Resolver I rankResolver I
        4 years ago

        Hi Anonymous ,

        Try below:

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