UK Retail Sales, Current year vs Previous Year #Power BI Model

Here is another Portfolio Item! I designed this model a while ago but took this long to write a blog post. Please watch my first You Tube video to see how I designed the model.Sorry sound is bad but lessons learned and more videos to come.

Dataset: ONS Website

Goal: To show current year vs Prior year data comparison

Video: https://youtu.be/puFN9u3ws4s

Power BI Report: https://app.powerbi.com/view?r=eyJrIjoiZDdmODA1NGMtNGJmOS00M2UwLWI5ZDgtNjJlYTk1MTExNGFmIiwidCI6IjM4YmU3MjU5LTMyMGQtNDZkYy04YzNiLWNkZDA5OTM1NGExMyIsImMiOjh9&pageName=ReportSectionee7d4dc500e628dad60d

Power BI Model: https://1drv.ms/u/s!Avm7gbgZtlMlykNdWv6KRrtV8ViY?e=Kyc6AX