Master Calendar

[gautik92]

I am new to Power BI

I need to create a Master Calendar Please Anyone can Explain step by step Procedure?

[Anonymous · Accepted solution]

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

[frederik]

Here's a simple way to a create a calendar in Power BI in 2 simple steps http://kohera.be/nl/blog/business-intelligence-nl-2/how-to-create-a-date-table-in-power-bi-in-2-simp...