Need help creating a Delta column based on varying columns

Anonymous 

Create a Delta Measure:

Delta =
VAR SelectedYears = VALUES(YourYearTable[Year]) // Replace with your actual year table
VAR Year1 = SELECTEDVALUE(SelectedYears, 0, 1) // Get the first selected year
VAR Year2 = SELECTEDVALUE(SelectedYears, 1, 0) // Get the second selected year

RETURN
IF(
Year1 <> 0 && Year2 <> 0,
[Values for Year2] - [Values for Year1], // Replace with your measure for each selected year
BLANK()
)

Adjust your existing values measure

Values_Year1 =
CALCULATE(
[Values],
FILTER(
'YourYearTable',
'YourYearTable'[Year] = SELECTEDVALUE(YourYearTable[Year], 0)
)
)

Values_Year2 = 
CALCULATE(
[Values], 
FILTER(
'YourYearTable', 
'YourYearTable'[Year] = SELECTEDVALUE(YourYearTable[Year], 1)
)
)

💌If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn