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!

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.