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 - The new calendar didn't seem to work, as it seemd to ignore the filter, and shows the entire range of the original calendar.

 

Would you have any suggestions?

 

The sample code was adjusted as shown below ... 

 

NEW_CALENDAR = 
VAR __table = ADDCOLUMNS(ALL('CALENDAR'[Date]),"__Measure",'CALENDAR'[Is In Date Range])
RETURN
FILTER('CALENDAR','CALENDAR'[Is In Date Range] = "Y")

A picture of the original calendar and new calander is below.  I am wanting the New Calendar to show only 5/12/2018 to 5/20/2018

 

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

Anonymous, not sure, I created it in my test environment and it seems to work. See attached Page 10. Calendar, New Calendar and Measure 4.

  • 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.