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 , 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?
I didn't get any errors using this (I changed the way the calendar table was created - using
Date Table = CALENDAR(Date (2018, 1, 1), DATE( 2022, 12, 31))
Then I used this method: BUT I didn't get ANY results.