Hi John Makwangula,
Thank you for reaching out to us on Microsoft Q&A forum.
We tried from our end; it's working fine for us. Kindly refer the below screenshot.
Please follow the steps whatever mention in exercise unit 5 of module https://learn.microsoft.com/en-gb/training/modules/automate-data-cleaning-power-query/5-lab.
If you are still facing any issue, please let us know in the comments. We are glad to help you.
If the information is helpful, please Accept Answer so that it would be helpful to community members.
Thank you.