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.