Forum Discussion
Helper ICalculate difference to be represented on a Matrix
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!
,
Super Userrokacl 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!
,
Helper ITotal 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/m-p/839241