Forum Discussion
Specific Calendar template
- 3 years ago
Hi Mederic
You can download an M query script of a date table from the following blog: All in One: Script to Create Date Dimension in Power BI using Power Query - RADACAD
After getting a date table from it, you can modify its steps to meet your own requirements. If you want some new columns, you can add custom columns. Here is a blog including how to create some custom columns. Create Calendar Table Using Power Query M Language (mssqltips.com)
If you want some speficial columns, you can tell us the logic to get them and provide some sample expected result here, so we can try to help provide some M scripts to get them.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Mederic So the easiest way would be to simply import that Excel table into Power BI as your date table...