I have a question regarding levels. I’m using a date column truncated to month as a level. I would like to have another level of date truncated to year but I cannot add the same date column twice. Do I have to create a year column to do this?
Yes to do this you can make a new column in your base columns that is just the original date column. So basically just take the column name out of the Truncated column and use it as a formula.
DateTrunc(“month”, [Date Column])
You’ll just have to type in [Date Column] as a formula and then you’ll have your original column that you can then truncate to year