Difference between two columns in matrix

[Anonymous]

Hi,

I have a dynamical matrix following. Two columns are dynamical based on period I select for example 2018.06. 

I want to know how to make a difference (Actual - Budget). 

I am looking forward to hearing from you soon.

Best regards.

Wei

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

Just create three measure as below:

Actual = CALCULATE(SUM(Table1[Value]),FILTER(Table1,Table1[Kind]="Actual"))

Budget = CALCULATE(SUM(Table1[Value]),FILTER(Table1,Table1[Kind]="Budget"))

Difference = [Actual]-[Budget]

Then do not drag [Kind] field (Actual - Budget) into matrix Columns value and [Value] into matrix Value. Just drag these three measure into Value.

Result:

Best Regards,

Lin