Forum Discussion

Mederic's avatar
Mederic
Post Patron
3 years ago
Solved

Specific Calendar template

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 a...
Need Help
Mederic's avatar
Mederic
Post Patron
3 years ago

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

v-jingzhang's avatar
v-jingzhang
Community Support
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's avatar
    Mederic
    Post Patron
    3 years ago

    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