cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SRK_23 Regular Visitor
Regular Visitor

% evolution rate line

Hi, how can I add a % evolution line from one month to another on my graph ?

 

file here: http://www.sendbox.fr/6462f8c487d27d3e/Evolution_status.pbix

 

Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: % evolution rate line

Hi @SRK_23

 

You may refer to below measure. Here is the sample file for your reference. If it is not your case, please explain more about your expected output % evolution rate.

1_CurrentActiveClient =
CALCULATE (
    COUNT ( 'Life cycle'[entityId] ),
    FILTER ( 'Life cycle', 'Life cycle'[currentStatus] = "Active" )
)
2_LastActiveClient =
CALCULATE (
    [1_CurrentActiveClient],
    FILTER (
        ALL ( WoW ),
        VALUE ( WoW[Year_Month] )
            = VALUE ( MAX ( WoW[Year_Month] ) ) - 1
    )
)
% evolution rate =
IF (
    NOT ( ISBLANK ( [1_CurrentActiveClient] ) ),
    DIVIDE ( [1_CurrentActiveClient] - [2_LastActiveClient], [2_LastActiveClient] )
)

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: % evolution rate line

Hi @SRK_23

 

You may refer to below measure. Here is the sample file for your reference. If it is not your case, please explain more about your expected output % evolution rate.

1_CurrentActiveClient =
CALCULATE (
    COUNT ( 'Life cycle'[entityId] ),
    FILTER ( 'Life cycle', 'Life cycle'[currentStatus] = "Active" )
)
2_LastActiveClient =
CALCULATE (
    [1_CurrentActiveClient],
    FILTER (
        ALL ( WoW ),
        VALUE ( WoW[Year_Month] )
            = VALUE ( MAX ( WoW[Year_Month] ) ) - 1
    )
)
% evolution rate =
IF (
    NOT ( ISBLANK ( [1_CurrentActiveClient] ) ),
    DIVIDE ( [1_CurrentActiveClient] - [2_LastActiveClient], [2_LastActiveClient] )
)

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.