Variance Column

[Anonymous]

Hello all,

I need to add a variance column to show Actuals VS Budget variance

For example here for allocated fringe benefits I need the variance column to display the value "-1,171.82"

But my data in excel is set up like this:

Any help is appreciated

[themistoklis · Accepted solution]

Hello @Anonymous 

Based on the data that you shared with us I created 3 measures:

GLBUD = CALCULATE(SUM(Sheet1[Total]), FILTER(Sheet1, Sheet1[Year_Code] = "GLBUD2021"))

GLACT = CALCULATE(SUM(Sheet1[Total]), FILTER(Sheet1, Sheet1[Year_Code] = "GLACT2021"))

Diff = [GLACT]-[GLBUD]

Then I created a table (not a matrix) and added all the relevant attributes.

See attached PowerBI file