Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Create second Calendar table from an original Calendar table

Hi -   I a have calendar table with with two columns, Date [=Calendar(Date(2015, 1, 1), Date(2018, 12, 31)] and a Measure [= "Y" or "N"].   I want create a second calendar table that includes the...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Greg - I didn't see any attachments (Go Bucks! ... I see you are from Columbus.)

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Got it.  Thanks.   And yes your example works.

     

    In my example, the indicator (Measure4) in Calendar is dynamic based on a slicer value so the dates with "Y" (Measure4) changes from slicer to value to value.  And for whatever the reason, Measure4 in New Calendar won't change and mirror what is in Calendar.  

     

    Thanks for your help.

     

     

     

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      7 years ago

      Anonymous - Yes, unfortunately that is correct. A calculated table is not dynamic, it only updates upon data refresh. Let me think about that and what you are trying to accomplish. Can you provide a use case? Because it should be possible to generate a measure that essentially filters your table correctly and provides the appearance of another calendar table but the usefulness of that is going to depend on what you are actually trying to accomplish.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Greg_Deckler

         

        I can provide a pbix file which will have have the exact specifics of what I am trying to accomplish.  Is that what you mean by 
        "use case"? 

         

        I will try to get that this evening.

         

        Thanks, Mark