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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi jemalosa 

 

Can you provide us with a solution, so that others who are experiencing similar problems can also benefit from it.

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jemalosa's avatar
jemalosa
Frequent Visitor
2 years ago

Hello Jaylenly,

 

any ideas?

 

I thought I had the solution but it doesn't give me the correct data, can you help me?

This is the formula I used:

Variacion_Precio_GAP =
VAR FechaActual = MAX('Licencias WS / SQL'[Fecha])
VAR PrecioGAPActual = 'Licencias WS / SQL'[Precio GAP]
VAR PrecioGAPAnterior =
    CALCULATE (
        MAX ( 'Licencias WS / SQL'[Precio GAP] ),
        FILTER (
            'Licencias WS / SQL',
            'Licencias WS / SQL'[Producto] = EARLIER ( 'Licencias WS / SQL'[Producto] )
                && 'Licencias WS / SQL'[Fecha] < FechaActual
        )
    )
RETURN
    IF (
        ISBLANK ( PrecioGAPAnterior ),
        BLANK (),
        DIVIDE ( PrecioGAPActual - PrecioGAPAnterior, PrecioGAPAnterior )
    )