Calculating YoY % Change but exclude next year

[JT_MSUK]

Hi, I have three measures setup for the cumulative amount and change:

Current Year (YTD)

Members YTD  = CALCULATE([Members],DATESYTD(DATEADD(CalendarTable[Date].[Date],0,Year)))

Last Year (Hidden)

Members LYTD = CALCULATE([Members],DATESYTD(DATEADD(CalendarTable[Date].[Date],-1,Year)))

 % Change

Members Cumulative % = DIVIDE([Members YTD]-[Members LYTD],[Members LYTD])

This is in a parameter, so when I click YTD it shows all my data between 2000-2023, and when I click % Change it'll show the changes over year - all working fine, however the % Change also adds in 2024 with -100%. How do I exclude next year?

[amitchandak · Accepted solution]

@JT_MSUK , Try like

% Change Members Cumulative % =

if( not(isblank([Members YTD])) ,

DIVIDE([Members YTD]-[Members LYTD],[Members LYTD]), blank())

[JT_MSUK]

That did the trick, thanks! 🙂