Forum Discussion
switch using date ranges
I have a DATE table with the following columns Date (DATE format), (the following columns are all Whole Numbers) WeekNum, Month, Day, Year, Qtr, End Date (DATE format), SprintNumber (whole number) (...
Anonymous , do not use MAX as this column max will take max date. Also, remove values
like
Switch(true(),
Date[Month] = 8 && Date[Year] =2009 , 1,
Date[Month] = 11 && Date[Year] =2009 , 2
)
Also in case you trying some custom financial calendar refer my blog
amitchandak Thank you - I cleaned it up a bit. Its not seeing the second line where month = 11 and month = 4. Its only giving results as Sprintnumber 1 and sprint number 3. When month = 11 or greater, it doesn't give the result sprintnumber 2