Forum Discussion

mdrammeh's avatar
mdrammeh
Icon for Helper III rankHelper 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 5...
Need Help
Show and Tell
Tutorial Requests
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
    Icon for Helper III rankHelper 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?

      • mdrammeh's avatar
        mdrammeh
        Icon for Helper III rankHelper III
        9 years ago

        The lookup is supposed to group the values in the column by:

         

        • 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

        Right now, I have only been able to create two with the conditional format feature. I need to be able to do the following using DAX in Power Query: