To create a new table we have to go to Power Query

Copy of Copy of class Car def init(self, brand, model) self,brand = brand self,model = model_enhanced.png

Then Right Click on the left side > New Query > Other Sources > Blank Query

Copy of Copy of class Car def init(self, brand, model) self,brand = brand self,model = model (1)_enhanced.png

Rename it to dim_date

Search Google “create date table in power query”

Go to the Microsoft official page

Copy of Copy of class Car def init(self, brand, model) self,brand = brand self,model = model (2)_enhanced.png

Copy & paste the formula

Copy of Copy of class Car def init(self, brand, model) self,brand = brand self,model = model (3)_enhanced.png

Now we want a start & end point of date, and we find the date in the “fact_sales_monthly” table

At first click on the filter option > Sort Descending > First cell is the Starting Date

Copy of Copy of class Car def init(self, brand, model) self,brand = brand self,model = model (4)_enhanced.png

Then click on the filter option > Sort Ascending > First cell is the End Date

Copy of Copy of class Car def init(self, brand, model) self.brand = brand self.model = model (5).png