Forum Discussion

Prarabdha_07's avatar
Prarabdha_07
Frequent Visitor
2 years ago
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...
Data Protection
  • Anonymous's avatar
    Anonymous
    2 years ago

    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 Xu

     

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

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

How do I extract data from another table that matches one or more columns?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Prarabdha_07 

     

    You can import the table and then use Merge or Append queries in Power Query, the "Merge queries" is to merge the columns of the tables together, and the "Append queries" is to add the row data.

     

    For more details, you can read related document link: 

    Merge queries overview - Power Query | Microsoft Learn

    Append queries - Power Query | Microsoft Learn

     

    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.