Calculate daily percentage growth (Covid 19 Colombia)

[ManuelEspitia]

Hello

I need to calculate the daily percentage variation of Covid19 cases. I have the measures of daily cases and cumulative cases. How can I calculate the percentage variation of each day, of those two measures?

Thanks for the help.

[jdbuchanan71 · Accepted solution]

@ManuelEspitia 

You can use a variable to calculate the previous days value for your measure and show the % change like so:

Cases % change from prior day = 
VAR _pd = CALCULATE ( [Confirmed Cases], DATEADD('cases'[Date],-1,DAY) )
RETURN
DIVIDE([Confirmed Cases],_pd)-1

[jdbuchanan71 · Accepted solution]

@ManuelEspitia 

You can use a variable to calculate the previous days value for your measure and show the % change like so:

Cases % change from prior day = 
VAR _pd = CALCULATE ( [Confirmed Cases], DATEADD('cases'[Date],-1,DAY) )
RETURN
DIVIDE([Confirmed Cases],_pd)-1

[ManuelEspitia]

@jdbuchanan71Hi. Why do we add -1 after the Divide function between the confirmed_cases and the variable?

[jdbuchanan71 · Accepted solution]

If you don't you get the ratio rather than the growth.

Take 11 vs 10

11/10 = 110%

110% - 1 = 10% growth

[ManuelEspitia]

Great, that's how it was, thank you.

Do you know now how can I get the case growth factor out? Here's how I have the model now: