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 as the below.

Also, is it possible to attach Excel files to this forum?

Thank you in advance for your help

Regards

Need Help

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    Mederic So the easiest way would be to simply import that Excel table into Power BI as your date table...

  • 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