Forum Discussion

YB's avatar
YB
Frequent Visitor
4 years ago
Solved

Need help with TOTALYTD

Hi folks,   I have been trying to figure out how to compare measures year over year for the same time period.  In this particular case I'd like to get from Jan 1st to Today (including the same time...
Need Help
  • YB's avatar
    YB
    4 years ago

    Ok, I found a solution but it's not very elegant.

     

     

    YTD Last Year = CALCULATE([Year to Date], DATEADD ('Calendar'[Date], -1, YEAR ), 'Calendar'[Date] <= DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())))

YTD 2 Years Ago = CALCULATE([Year to Date], DATEADD ('Calendar'[Date], -2, YEAR ), 'Calendar'[Date] <= DATE(YEAR(TODAY())-2,MONTH(TODAY()),DAY(TODAY())))

     

CNENFRNL's avatar
CNENFRNL
Community Champion
4 years ago
YTD Last Year =
CALCULATE(
    COUNT( 'TEST'[id] ),
    DATEADD(
        CALCULATETABLE( DATESYTD( 'Calendar'[Date] ), 'calendar'[Date] <= today ),
        -1,
        YEAR
    )
)
YB's avatar
YB
Frequent Visitor
4 years ago

Thanks, I gave it a try but it still didn't give me the desired result.