Forum Discussion
Anonymous
4 years agoNot applicable
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...
- 4 years ago
Hi Anonymous ,
Try below:
Tickets Last Year = CALCULATE( [TICKET_COUNT],SAMEPERIODLASTYEAR('DateAdd(('Calendar'[Date],1,Day)))
keshavagrawal27
4 years agoResolver I
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.
- Anonymous4 years agoNot applicable
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."- keshavagrawal274 years agoResolver I
Hi Anonymous ,
Try below:
Tickets Last Year = CALCULATE( [TICKET_COUNT],SAMEPERIODLASTYEAR('DateAdd(('Calendar'[Date],1,Day)))