Forum Discussion

SRK_23's avatar
SRK_23
Helper I
7 years ago
Solved

% 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,
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

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