Forum Discussion
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...
Greg_Deckler
Community Champion
Community ChampionSo, you should be able to do that like this:
New Calendar =
VAR __table = ADDCOLUMNS(ALL('Date'),"__Measure",[Measure])
RETURN
FILTER(__table,[__Measure] = "Y")
I will give that a try . Thank you. Just such a newbe to DAX, "simple" things take questions to learn.