How to compare the values in entire column with other values in another table?

[Anonymous]

Hi all,

I have two tables, Table A and Table B. I want to get the product names (highlighted) in Table B based on the price. This can be done easily in Excel using IF function (as shown in the screenshot above). However, I'm not sure how to do it in PowerBI. I want to fix the formula for the Product column in Table B which means I don't need to change the formula in future. So let say if I changed the name for Product A to Product C and Product B to Product D in Table A, the product names in Table B will change as well, i.e., the product names in Table B is purely based on how we define it in Table A.

I'm not sure how to do it in PowerBI using DAX formula since the number of row for two tables are different. Hope to get some advise from you guys, thank you!

[amitchandak · Accepted solution]

@Anonymous ,Try a new column like

new column = maxx(filter(TableA, TableA[price] = TableB[Price]), TableA[Product])

Refer log - https://www.youtube.com/watch?v=czNHt7UXIe8