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...
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?
