Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
win_anthony
Partner - Contributor III
Partner - Contributor III

Creating a Variable for a Dimension

Is there a way for you to create a variable for a Dimension? The target is to have a variable that will recognize that a new month will be added to a dimension. Example sample data below. Current month end at 2020-M04 (April). Next month will add 2020-M05. I ultimately do not want to hard code dates and have to maintain it. Just wondering if this is possible. 

Please let me know your thoughts.

Current_DateNext_MonthMonth_After
2020-M012020-M012020-M01
2020-M022020-M022020-M02
2020-M032020-M032020-M03
2020-M042020-M042020-M04
 2020-M052020-M05
  2020-M06

 

 

1 Reply
dplr-rn
Partner - Master III
Partner - Master III

not clear what you mean.

the date column will automatically load all the dates thats there in data when it reloads. Why do you need a variable as dimension, why not the date column ?

please elaborate what you are trying to achieve