Forum Discussion

cristiannt's avatar
cristiannt
Frequent Visitor
9 years ago

Percentage from previous row

Hey! How you doing guys?   I'd like to know the calculation for a measure that should have the following behaviour: It should calculate the percentage between the actual number of 'Solicitudes' an...
Need Help
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

cristiannt

 

Using your sample data you can use a calculated column:

 

 

Previo =
VAR EstadoPrev = Table1[Estado] - 1
RETURN
    DIVIDE (
        CALCULATE ( VALUES ( Table1[Solicitudes] ) ),
        CALCULATE (
            VALUES ( Table1[Solicitudes] ),
            FILTER ( ALL ( Table1 ), Table1[Estado] = EstadoPrev )
        )
    )

 

 Or you can use the next measure:

 

PrevioM =
VAR EstadoPrev =
    MIN ( Table1[Estado] ) - 1
RETURN
    IF (
        HASONEVALUE ( Table1[Estado] ),
        DIVIDE (
            CALCULATE ( SUM ( Table1[Solicitudes] ) ),
            CALCULATE (
                SUM ( Table1[Solicitudes] ),
                FILTER ( ALL ( Table1 ), Table1[Estado] = EstadoPrev )
            )
        )
            + 0
    )