Need help to calculate from previous cell

[Vaibhav3008]

Hi,

I have Client, Period and Hours column. Need to calculate Net change and %Growth columns in power BI

Please help in achieving this.

[Alf94]

Hi @Vaibhav3008 ,

Can you please try the following?

Net change = 
        IF(
            SELECTEDVALUE( 'Table'[Client] ) =
            CALCULATE(
                MIN( 'Table'[Client] ),
                OFFSET(
                    -1,
                    ORDERBY( 'Table'[Client], ASC, 'Table'[Period], ASC )
                )
            ),
            CALCULATE(
                MIN( 'Table'[Hours] ) -
                CALCULATE(
                    MIN( 'Table'[Hours] ),
                    OFFSET(
                        -1,
                        ORDERBY('Table'[Client], ASC, 'Table'[Period], ASC)
                    )
                )
            )
        )

% Growth = 
    DIVIDE(
        [Net change],
        CALCULATE(
            MIN( 'Table'[Hours] ),
            OFFSET(
                -1,
                ORDERBY( 'Table'[Client], ASC, 'Table'[Period], ASC )
            )
        )
    )

Result:

If I answered your question, please mark my post as a solution.

Best,

[Vaibhav3008]

Thanks for the reply,

I applied it to my table and it says : Parameter is not the correct type

Can you please help resolve it

[Alf94]

@Vaibhav3008,

This is ok. Just validate your measure and put it in a visual, it should work.