Forum Discussion

rokacl's avatar
rokacl
Icon for Helper I rankHelper I
6 years ago
Solved

Calculate difference to be represented on a Matrix

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:

 

Need Help
Tips and Tricks
  • parry2k's avatar
    parry2k
    6 years ago

    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!

     

    ,

     

2 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    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!

     

    ,