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
Go to Solution.
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.
COUNT ( 'Life cycle'[entityId] ),
FILTER ( 'Life cycle', 'Life cycle'[currentStatus] = "Active" )
ALL ( WoW ),
VALUE ( WoW[Year_Month] )
= VALUE ( MAX ( WoW[Year_Month] ) ) - 1
% evolution rate =
NOT ( ISBLANK ( [1_CurrentActiveClient] ) ),
DIVIDE ( [1_CurrentActiveClient] - [2_LastActiveClient], [2_LastActiveClient] )
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.