Forum Discussion
Solved
Calculate column with 2 tables without relation
Hi experts! I'm very new in Power BI and DAX and I would like to request your help, pls... I have 2 different tables with different fields and without relation, to explain fastly, I gonna use...
Hey afi_imco,
For finding values between two tables without a relationship you can use the LOOKUPVALUE function. If I understand your question correctly, you want it to return text_product when ID_sender is equal to device. If so, the formula looks like this:
TEXT_PRODUCT = LOOKUPVALUE(Product_box[text_product],Product_box[device],OOS_Calculations[ID_sender])
Hope this helps.
Dear Anonymous,
It perfectly fit my current requirement. I appreciate your help!