Calculate difference to be represented on a Matrix

[rokacl]

Hi,

I need to make 2 columns to represent the difference between each number on the columns, my database is like this, and this arrows show what difference I need, thanks

And the matrix I need to add difference:

[parry2k · Accepted solution]

@rokacl create measures like this, change column and table name as per your model

Base Measure = SUM ( Table[Monto] )

Plan de Nagocios = CALCULATE ( [Base Measure], Table[Origen] = "Plan de Nagocios" ) 

Proyeccion Actual = CALCULATE ( [Base Measure], Table[Origen] = "Proyeccion Actual" )

Proyeccion Anterior = CALCULATE ( [Base Measure], Table[Origen] = "Proyeccion Anterior" )

A - B Measure = [Plan de Nagocios] - [Proyeccion Actual]

B - C Measure = [A - B Measure] - [Proyeccion Anterior]


 

drop these measures in a table visual and you will get the result.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

,

[rokacl]

Total solution, thank you very much!! 🙂

PD: I was also cheking this one, that was almost the same, very useful and harder, because of sliders https://community.powerbi.com/t5/Desktop/Difference-between-two-columns-selected-by-slicer-in-matrix...