% evolution rate line

[SRK_23]

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,

[v-cherch-msft · Accepted solution]

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