Forum Discussion

mdrammeh's avatar
mdrammeh
Helper III
9 years ago

Need help with Conditional Lookup

Need help with conditional lookup to group the following measures in Power Query and Power BI

  • Greater than 0 days but less than or equal to 40 days
  • Greater than 40 days but less than or equal to 56 days
  • Greater than 56 days but less than 366 days
Need Help
Show and Tell
Tutorial Requests

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    You're going to need to be a lot more clear. Lookup what from where? What is supposed to be meeting these criteria and how are you defining them? What part of this do you want to do in Power Query? Measures don't exist in the query editor so that doesn't make sense.

    • mdrammeh's avatar
      mdrammeh
      Helper III
      9 years ago

      Great point :) I am including a table below with some sample data. The data is located in a database with millions of record. The lead days column is what I would like to group in Power Query or Power BI:

       

      Engnr Lead DaysLookup
      -362 
      -362 
      4964 
      40 
      40 
      67 
      -1064 
      -21 
      365 
      1 
      1 
      1 
      1 
      1 
      1 
      1096 
      4 
      366 
      366 
      366 
      366 
      365 
      1 
      1 
      1 
      1 
      0 
      0 
      3 
      3 
      3 
      3 
      -999 
      -999 
      2928 
      0 

       

      I hope this makes sense?

       

      Thanks for the feedback

       

      MD

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        What's supposed to happen in the Lookup column? What are you looking up? Where is it?