Forum Discussion
Solved
Power BI IF condition with Different table Columns
Hii, I am connecting two Tables Customer (StoreID) and Store(BusinessEntityID) -- I need to create a IF Measure using Columns from both the Tables like this -- Columns from Differen...
Hi Prarabdha_07
After my testing, you can put the BusinessEntityID field in place of the StoreID field in the visualization if you wish.
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Prarabdha_07
The following steps are for your reference:
sample:
Merge two tables in Power Query
Expand the table
Close & Apply
Create a measure as follows:
Measure = IF(MAX([Name]) = "A Bike Store" && MAX([Customer.StoreID]) = 934, "Working", "Not Working")
Final Output:
If there are still questions, please feel free to ask me.
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
We don't want to merge as data is huge
Will consider this as the last option