Forum Discussion
Need help with Conditional Lookup
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 Days | Lookup |
| -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
What's supposed to happen in the Lookup column? What are you looking up? Where is it?
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:
It looks like you're just creating a bucket column. There's no lookup going on that I can see. You would just use a normal IF formula in DAX, identical to an Excel IF formula. IF(<condition>, <result if true>, <result if false>)