This article continues to build on my COVID Case Fatality Rate report for Australia. Something happened with the global source data this week – in short, it was wrong. This is a global database and I am sure there are many people diligently trying to keep the data up to date and accurate. But sometimes things go wrong, so what do you do? In the video today, I show you one way to correct data when you don’t have control of the source.
I used the approach covered in the video because the data is simple and the effort for this quick fix is low. There is another approach that is more effort and is ideal when the data are more complex you can read that article here https://exceleratorbi.com.au/fixing-incorrect-data-in-power-bi/.