Forum Discussion

Justair07's avatar
Justair07
Resolver 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
rajulshah's avatar
rajulshah
Resident 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
Resolver 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
    Resident 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
      Resolver 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