Forum Discussion

Mark95's avatar
Mark95
Frequent Visitor
3 years ago

3 condition lookup Power Query

Hi All! I would like to import a column (Sales Person name) to tansactions details query and to do this, i need to meet 3 conditions. First one is simple, Customer ID needs to match, the second a...
Need Help
AntrikshSharma's avatar
AntrikshSharma
Community Champion
3 years ago

Mark95 Post sample data or upload the PBIX to google drive and share the link

  • Mark95's avatar
    Mark95
    Frequent Visitor
    3 years ago

    AntrikshSharma 
    I have uploaded an example document presented below as well as a snipp of it.
    Issue Example Excel file 

     

    Below is the formula i tried using in column E of the example file, it works well on small tables but the one my query generets is 100k+ lines, with the lookup table being 40k+ lines.

    =IFERROR(INDEX(Lookup_Table[Sales Rep],MATCH(1,(Lookup_Table[Account ID]=[@AccountID])*(Lookup_Table[Assignment start month year]<=[@YearMonth])*(Lookup_Table[Assignment End Month Year]>=[@YearMonth]),0)),"Account not Assigned")

    Hope this helps.

    Thank you for taking a look into this, hope i will in the future 🙂