Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone,
This is my first post on this forum,
Please excuse me if this topic has already been discussed.
I have an Excel file with a date column and would like to get the same template as the below.
Also, is it possible to attach Excel files to this forum?
Thank you in advance for your help
Regards
Solved! Go to Solution.
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.
Hello @Greg_Deckler ,
Thank you for your answer but I am not sure I understood everything.
I am unfortunately not an English speaker.
Probably I did not explain myself well,
Will this new image make the explanation clearer ?
Thanks in advance
Regards
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.
Dear @v-jingzhang
Thank you very much for your message and the links which will be very useful to me.
The Calendar script is very handy and will be useful in many cases.
I will be able to continue reproducing the exercise in the link below as I am particularly interested in this subject : https://jiaopengzi.com/996.html
I put this thread in resolution but if someone has already made this type of template, I am interested
Thanks again to the Power BI community
Regards
@Mederic So the easiest way would be to simply import that Excel table into Power BI as your date table...