Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
I am new to Power BI
I need to create a Master Calendar Please Anyone can Explain step by step Procedure?
Solved! Go to 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
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
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...
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 57 | |
| 52 | |
| 45 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 108 | |
| 108 | |
| 39 | |
| 33 | |
| 26 |