topic Re: Need help to calculate from previous cell in DAX Commands and Tips

Need help to calculate from previous cell

Vaibhav3008 — Wed, 05 Jul 2023 05:42:36 GMT

Hi,

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

Please help in achieving this.

Re: Need help to calculate from previous cell

Alf94 — Wed, 05 Jul 2023 07:38:11 GMT

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,

Re: Need help to calculate from previous cell

Vaibhav3008 — Wed, 05 Jul 2023 08:24:41 GMT

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

Re: Need help to calculate from previous cell

Alf94 — Wed, 05 Jul 2023 12:38:52 GMT

Vaibhav3008,

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