Forum Discussion

Justair07's avatar
Justair07
Icon for Resolver I rankResolver I
6 years ago

Trying to Create a Dynamic Calendar

Hi,   I'm trying to use the CALENDAR function to create a dynamic calendar table. Here is my DAX: TimelineDates = CALENDAR(DATE([SelectedYear],01,01),DATE([SelectedYear],12,31)) [SelectedYear] ...
Need Help
Justair07's avatar
Justair07
Icon for Resolver I rankResolver I
6 years ago

Hi rajulshah ,

 

I was afraid of that. Do you know of another way I can achive my overall goal? Another method to create a dynamic calender based on a slicer selection?

 

Thank you

 

-Justair07

rajulshah's avatar
rajulshah
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Justair07,

 

Do you want a physical table or table that is to be used in a measure?

  • Justair07's avatar
    Justair07
    Icon for Resolver I rankResolver I
    6 years ago

    Hi rajulshah,

     

    I might not understand the difference between a physical table and a table so forgive me but my initial thought is either should work. I have a calander already created entirley from M in the Power Query Editor. My goal was to have the dynamic calender only show a date range for a single year based on the slicer selection. Hope this answers your question.

     

    Thank you,

    -Justair07

    • rajulshah's avatar
      rajulshah
      Icon for Resident Rockstar rankResident Rockstar
      6 years ago

      Justair07,

       

      Yes, I got you. But I don't think so there is any other way for that. 

      • Justair07's avatar
        Justair07
        Icon for Resolver I rankResolver I
        6 years ago

        rajulshah ,

         

        Darn. Well thank you. I'll leave this posted for another day or so as unsolved to see if someone has an idea of how to do this.

         

        Thank you for all of your help!

         

        -Justair07