Forum Discussion

jemalosa's avatar
jemalosa
Frequent Visitor
2 years ago
Solved

Calculated column

Hello, I have tried to create a calculated column so that in that table I get values of percentage variation with respect to the previous month. As it is an example table and as you can see the mont...
  • jemalosa's avatar
    jemalosa
    2 years ago

    Hi again,

    I have found the solution:

    Variacion_Precio_GAP =

    VAR ProductoActual = 'Licencias WS / SQL'[Producto]
    VAR precioanterior =CALCULATE (
        MAX('Licencias WS / SQL'[Precio GAP]),PREVIOUSMONTH('Licencias WS / SQL'[Fecha]),
        FILTER (
            ALL('Licencias WS / SQL'),
            'Licencias WS / SQL'[Producto] = ProductoActual
        )
    )
    RETURN
    DIVIDE ('Licencias WS / SQL'[Precio GAP]- precioanterior, precioanterior)
     
    Regards
jemalosa's avatar
jemalosa
Frequent Visitor
2 years ago

Resolved. Thank you