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
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

So, you should be able to do that like this:

 

New Calendar = 
VAR __table = ADDCOLUMNS(ALL('Date'),"__Measure",[Measure])
RETURN
FILTER(__table,[__Measure] = "Y")
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