Forum Discussion

topazz11's avatar
topazz11
Helper III
6 months ago
Solved

Power Query Look Up Value From Another Table

Power Query Look Up Value From Another Table Based On date and other condition.

How do I pick up the value in Type column based on date and item as below?

Thanks in advance.

 

Need Help
  • BeaBF's avatar
    BeaBF
    6 months ago

    topazz11 Hi! 

    You cna find the solution in the pbix attached.

    Let me know.

     

    BBF


    ๐Ÿ’ก Did I answer your question? Mark my post as a solution!

    ๐Ÿ‘ Kudos are appreciated

    ๐Ÿ”ฅ Proud to be a Super User!

5 Replies

  • BeaBF's avatar
    BeaBF
    Super User
    6 months ago

    topazz11 Hi! 

    You cna find the solution in the pbix attached.

    Let me know.

     

    BBF


    ๐Ÿ’ก Did I answer your question? Mark my post as a solution!

    ๐Ÿ‘ Kudos are appreciated

    ๐Ÿ”ฅ Proud to be a Super User!

    • BeaBF's avatar
      BeaBF
      Super User
      6 months ago

      topazz11 Have you seen the solution in the pbix?

       

      BBF


      ๐Ÿ’ก Did I answer your question? Mark my post as a solution!

      ๐Ÿ‘ Kudos are appreciated

      ๐Ÿ”ฅ Proud to be a Super User!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 months ago

    Hi,

    This calculated column formula work

    =CALCULATE(MAX(Table3[ะขัƒั€ะต]),FILTER(Table3,Table3[ltem]=EARLIER(Table2[Item])&&Table3[Start]<=EARLIER(Table2[Date])&&Table3[End]>=EARLIER(Table2[Date])))

    Hope this helps.