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