data in excel, budget vs actual = variance formula

[ckoulis]

Hello all,

i have the below data in excel

and then i have a powerbi table

i would like to have another column with the variance per month.

any idea?

thank you

[samdthompson]

Hello, you need to have the three measures i mentioned earlier, each dragged in. I think you have just a single measure there with the actual/budget as a column header.

[samdthompson · Accepted solution]

Hello you probably want to make three measures (if you havent already made the first 2)

1. Actual=SUM(Table1[Actual])

2. Budget=SUM(Table1[Budget])

3. Variance=[Actual]-[Budget]

Drag them all into your table

[ckoulis]

thank you @samdthompson  that worked great but ihave a follow up.

i have a matrix and if i add the measure "Variance" at that matrix it appears at both columns like below

how can i remove the column marked with blue?

thanks in advance

[Ashish_Mathur]

Hi,

These measures should work

Budget total = calculate(sum(Data[amount]),data[type]="budget")

Actual total = calculate(sum(Data[amount]),data[type]="actual")

Variance = [budget]-[actual]

To your Table, visual, drag Month and Year from the Calendar table and the 3 measures written above.