Forum Discussion
Anonymous
2 years agoNot applicable
Variance Column
I have a matrix that looks like this company 2022 2023 2024 orders 2342 1234 5678 sales 2342...
- 2 years ago
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 )
Anonymous
2 years agoNot applicable
variance of orders from 2023 to 2024 in x, variance of sales from 2023 to 2024 in y, variance of income from 2023 to 2024 in z
Arul
Super User
2 years agoAnonymous ,
Correct if me if I'm wrong,
2024[orders]-2023[orders] likewise for others.