Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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) (...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I can't send the pbix. However here is a screen shot - YEAR is the same type. 

    I have also tried this 

     

     

     

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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

         

         

         

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Here is the DATE table - how I created it. 

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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. 

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello! - I'm making progress but still not there - The below function is not giving any errors, but Its giving a "1" for starting 8/1/2019 but NOT giving a "2" for the respective dates. It IS returning a "3" for dates starting 1/1/2020. Not sure what its not giving a 2 or 4