This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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...
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 27 | |
| 26 | |
| 25 | |
| 21 | |
| 14 |
| User | Count |
|---|---|
| 50 | |
| 47 | |
| 23 | |
| 18 | |
| 18 |