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) (...
amitchandak
Super User
Super UserAnonymous , Formula seems fine. The only doubt I have is that either Month of year is of data type text.
Can you share a sample pbix after removing sensitive data?
Here is the DATE table - how I created it.