Forum Discussion
Time filter help
Hello Community, For several days I have been dealing with a filter. I have a small calendar table, where I also have a column "Relative_cod" that goes from number 1 to 24, with 1 being the numb...
QTR = SWITCH(TRUE(),[RELATIVE_CODE]<= 4, [MTH],
[RELATIVE_CODE] < 7, DATEADD(Period[DATE],-21,MONTH),
[RELATIVE_CODE]<10, DATEADD(Period[DATE],-18,MONTH),
<some value for "else">)