Forum Discussion
SRK_23
7 years agoHelper I
% 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,
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
1 Reply
- v-cherch-msftMicrosoft Employee
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