Forum Discussion

TWijnen90's avatar
TWijnen90
New Member
2 years ago
Solved

SAMEPERIODLASTYEAR returns values from this year

Hi,   I'm using SAMEPERIODLASTYEAR to compare the number of incoming mails per month to the same month the previous year, but it appears to add the numbers from this year to last year.   The set-...
Need Help
  • amustafa's avatar
    amustafa
    2 years ago

    Adjust your DAX as...

     

    CALCULATE(
    [Totaal], 
    SAMEPERIODLASTYEAR(tbl_date[Date]),
    tbl_date[Year] = YEAR(TODAY()) - 1
)
amustafa's avatar
amustafa
Solution Sage
2 years ago

Adjust your DAX as...

 

CALCULATE(
    [Totaal], 
    SAMEPERIODLASTYEAR(tbl_date[Date]),
    tbl_date[Year] = YEAR(TODAY()) - 1
)