Master Calendar

Hi gautik92

There are several samples and/or how-to's out there where they'll tell you how to generate a master table. The easist way, that I find, is to generate a date table in SQL Server database and then import it into Power BI, while some of friends find Excel as a better place.

Have a look at some of the results form the following Google searches;

- Results for sql code to create date dimension

- Results for generate date table in power query

Hope this helps. 

Thanks

Kaz