Power BI - Convert Cumulative to Daily figures - COVID -19 Cases
Mark WiIlcock gave a great presentation as part of the London Business Analytics Group on how to create a Power BI Dashboard using COVID-19 national cases available daily from Public Health England.
This video follows the example in his workshop to show how to create a Power BI report using the PHE spreadsheet which requires conversion of cumulative figures to daily ones using DAX.
See Mark's resouces here - https://bit.ly/33zWQtp
The PHE dashboard is here - https://www.gov.uk/government/publica...
Our dashboard is available here - https://app.powerbi.com/view?r=eyJrIj...
Bing has a great COVID tracker - https://www.bing.com/covid
When there is more data we might want to chart it like this - • How To Tell If We're Beating COVID-19
The London Business Analytics Group is here - https://www.meetup.com/London-Busines...