Forum Discussion

Data_Tim's avatar
Data_Tim
New Member
3 years ago
Solved

Help with SAMEPERIODLASTYEAR

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 toda...
DAX
Sameperiodlastyear
  • tamerj1's avatar
    tamerj1
    3 years ago

    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" )
)
Data_Tim's avatar
Data_Tim
New Member
3 years ago

Thanks for getting back to me tamerj1 .

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

 

tamerj1's avatar
tamerj1
Community Champion
3 years ago

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" )
)
  • Data_Tim's avatar
    Data_Tim
    New Member
    3 years ago

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