Forum Discussion

wmeads001's avatar
wmeads001
Regular Visitor
6 years ago

Dynamic calendar

Hi   I am trying to create a dynamic calendar at the Month level (There is no need for day level)  I have created a master calendar with no problem and I am now trying to create the Dynamic period fi...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

So you want the first table displayed between StartYear and EndYear and you want Base Periods

 

Table = 
  VAR __Years = GENERATESERIES([StartYear],[EndYear],1)
  VAR __Months = { "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12")
  VAR __Table = 
    ADDCOLUMNS(
      GENERATE(__Years,__Months)
      "__Base Period",[Value1] & [Value2]
    )
RETURN
  SELECTCOLUMNS(__Table,"Base Period",[__Base Period])