Power Query Look Up Value From Another Table

[topazz11]

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.

[Ashish_Mathur]

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.

[BeaBF · Accepted solution]

@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]

@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!

[krishnakanth240]

Hi @topazz11 

Do you want to implement above logic on Power BI or Excel. Can you confirm 

[topazz11]

it is Power BI