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

     

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