topic Re: Help with SAMEPERIODLASTYEAR in DAX Commands and Tips

Help with SAMEPERIODLASTYEAR

Data_Tim — Wed, 04 Jan 2023 11:07:20 GMT

Happy new year all!

I am trying to use the SAMPERIODLASTYEAR function to count records from the previous year, so that I can compare them to the number of records for the current year (up until today's date). The problem I am running into is that the same day last year is counting records for the entire month, rather than just that corresponding day.

I have a field in my Date table [check] which checks the day number of the year so future days in the same month can be filtered out.

Any help to resolve this would be greatly appreciated. Many thanks

Re: Help with SAMEPERIODLASTYEAR

tamerj1 — Wed, 04 Jan 2023 11:22:14 GMT

Hi Data_Tim
Please try

Tickets LYTD = CALCULATE ( COUNT ( 'All Tickets'[sys_id] ), FILTER ( SAMEPERIODLASTYEAR ( DateTable[Date] ), DateTable[Check] = "True" ) )

Re: Help with SAMEPERIODLASTYEAR

Data_Tim — Wed, 04 Jan 2023 11:47:09 GMT

Thanks for getting back to me tamerj1 .

Unfortunately that doesn't work as the Filter is expecting to evaluate DateTable[Date] not DateTable[Check]

Re: Help with SAMEPERIODLASTYEAR

tamerj1 — Wed, 04 Jan 2023 11:55:43 GMT

Data_Tim
Appologies for that. Yes you are right this was supposed to be CALCULATETABLE

Tickets LYTD = CALCULATE ( COUNT ( 'All Tickets'[sys_id] ), CALCULATETABLE ( SAMEPERIODLASTYEAR ( DateTable[Date] ), DateTable[Check] = "True" ) ) Or Tickets LYTD = CALCULATE ( COUNT ( 'All Tickets'[sys_id] ), SAMEPERIODLASTYEAR ( DateTable[Date] ), FILTER ( ALL ( DateTable ), DateTable[Check] = "True" ) )

Re: Help with SAMEPERIODLASTYEAR

Data_Tim — Wed, 04 Jan 2023 12:11:50 GMT

That's worked for me - thanks for your help tamerj1 . Much appreciated