CODEWITHSUNDEEP
excelexcel-formulapowerbiexcel-2016
MmVv
MmVv

Reputation: 553

Calculate daily increase/decrease in COVID-19 cases / deaths

I was trying to plot some reports for Covid-19 cases around the Globe, using Excel and Power BI. With Power BI is easier and fancier to do definitely, but I need an Excel file or calculation that makes sense - similar to the PBI. What I actually wanted is to calculate the daily increase in new cases (with %) and also death rate but per day, or total death by day and so on..

I did some calculations (% of column total and I calculated one field to get death rate%) here using Pivot tables but not sure how to do daily increase/decrease? Did anyone get an idea for additional calculations? This is copied from PBI (calculations) which I wanna have similar in Excel - but I am not sure If I can calculate it properly (last 2 pictures).

The data source from the input data is here:

https://www.ecdc.europa.eu/sites/default/files/documents/COVID-19-geographic-disbtribution-worldwide.xlsx

enter image description here

enter image description here

enter image description here

enter image description here

Upvotes: 0

Views: 436

Answers (1)

Oliver Leung
Oliver Leung

Reputation: 812

You need an extra column for the result you want (e.g. daily increase/decrease), then you can plot either the waterfall chart, or using techniques similar to https://www.extendoffice.com/documents/excel/5945-excel-chart-display-percentage-change.html

Upvotes: 0

Related Questions