Forum Discussion
Variance Column
I have a matrix that looks like this company 2022 2023 2024 orders 2342 1234 5678 sales 2342...
Give this measure a try
Yearly Variance = VAR CurrentYear = SELECTEDVALUE('Date'[Year]) VAR PreviousYear = CurrentYear - 1 VAR Metric = SELECTEDVALUE('Metrics'[Metric]) RETURN SWITCH( TRUE(), Metric = "Orders", [Orders], Metric = "Sales", [Sales], Metric = "Income", [Income] ) - CALCULATE( SWITCH( TRUE(), Metric = "Orders", [Orders], Metric = "Sales", [Sales], Metric = "Income", [Income] ), 'Date'[Year] = PreviousYear )
Give this measure a try
Yearly Variance =
VAR CurrentYear = SELECTEDVALUE('Date'[Year])
VAR PreviousYear = CurrentYear - 1
VAR Metric = SELECTEDVALUE('Metrics'[Metric])
RETURN
SWITCH(
TRUE(),
Metric = "Orders", [Orders],
Metric = "Sales", [Sales],
Metric = "Income", [Income]
) -
CALCULATE(
SWITCH(
TRUE(),
Metric = "Orders", [Orders],
Metric = "Sales", [Sales],
Metric = "Income", [Income]
),
'Date'[Year] = PreviousYear
)