Forum Discussion
Variance Analysis
I have below "values" table: Account Client Service Line Ops Geo Year Period Scenario Data Source Currency Measure Manager RVP [Values] COR GDR Total COR Value Revenue Reven...
Anonymous I think it should be something like this, add the following measure and put in matrix visual.
Base Sum = SUM ( Table[Amount] )
Actual = CALCULATE ( [Base Sum], Table[Scenario] = "Actual" )
Budget = CALCULATE ( [Base Sum], Table[Scenario] = "Budget" )
Variance = [Actual] - [Budget]
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
parry2k , thank you for the reply.
I modified your solution to get the answer.
I am looking for EBITDA number which is Revenue - Expense (sum of COR and SGA) .
My equation:
Actual EBITDA = calculate([EBITDA], filter('values',[EBITDA]<>0),filter('values','values'[Scenario] = "Actual"))Budget EBITDA = calculate([EBITDA], filter('values',[EBITDA]<>0),filter('values','values'[Scenario] = "Budget"))EBITDA Variance = [Actual EBITDA]-[Budget EBITDA]This gets me the result. The only problem is that if I have to estimate the variance for Revenue,COR and SGA separately I would have to write 9 more equations. Is there an easy way to get all the variance analysis with minimum coding?
