Vlookup similar formula and Cant create Relationship error

[jimpatel]

Hi,

Thanks for looking at my post.

I am trying to replicate Vlookup formula something like =IFERROR(VLOOKUP([@Key],Keysheet,2,FALSE),0).

I have "Key" data and "Keysheet" data in power BI as seperate table. Issue is in some cases "Key" data have 0 as per vlookup and due to this i cant create a releationship in power bi between these two. Any idea of how to over come this please?

Much appreciated

Thanks

[jimpatel]

Hi,

Thanks for the reply. I am trying to link two tables with simlar concept as below. I am trying to link Column A and Column H please.

[Anonymous · Accepted solution]

Hi @jimpatel ,

Try add a column containing table2 in the table1, expand the new column. Then add a conditional column to judge whether it is the same with the column in the table1, and finally filter out the results you want.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jennratten]

You should be able to create a one to many relationship using the values in column H on the one side and the values in column A on the many side.  Can you please post snips of what your tables look like in Power Query?

[jennratten]

Hello - how do the two tables relate to each other?  There must have a field in common in order for a relationship to work.  If the only problem is that there are some zeros in the data, you can fiter those out in Power Query. If you need additional assistance, please post some examples of what your data looks like or sample data that resembles your scenario.