Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Difference between two columns in matrix

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

 

 

 

 

 

 

 

General Comment
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    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

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    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