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

     

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

      Hi Anonymous ,

      Try below:

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