Forum Discussion

blfox4's avatar
blfox4
New Member
5 years ago

Help with Formula in Power Query - IF(ISNA(VLOOKUP

Hello all,   I am fairly new to Power Query but determined to learn it. I have a question about translating an Excel function to Power BI. I've already searched around and came across different DAX...
Need Help
Jimmy801's avatar
Jimmy801
Community Champion
5 years ago

Hello blfox4 

 

creating a VLOOKUP in Power Query is not the best way to handle the issue. Yes, it's possible, but you are better of to join both tables, in case transforming the joined table, and then expand the value you need.

 

Hope this helps

 

Jimmy