Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have Client, Period and Hours column. Need to calculate Net change and %Growth columns in power BI
Please help in achieving this.
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,
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
User | Count |
---|---|
51 | |
27 | |
19 | |
18 | |
14 |
User | Count |
---|---|
91 | |
86 | |
39 | |
23 | |
22 |