![]() Matched Column = Calculated Column Name.Matched Column = IF(RELATED('Product Table 1')='Product Table 2',"Matches","UnMatch") Add the new column and apply the below-mentioned DAX formula to it. Here in this example country column is the same in both the tables.Make sure both the tables have one same column so that it will make a relationship into it. Open the Power Bi desktop, and load the table data into it.In this example, I am going to use the Product table data you can download it from here. Let us see how we can compare two columns in different tables using DAX or Measure in Power BI, ![]() This is how to compare multiple columns with two different tables in Power BI.Ĭheck: Power BI Matrix Multiple Column Power Bi DAX compares two columns in other tables How to compare multiple columns in Power BI It compares two tables and gets values, and displays the result as True or False according to the condition.Now in the below screenshot, you can see that the New Result column displays the result based on the condition applied.Sold Amount & Product & Country= Column names.MAXX ( RELATEDTABLE ( 'Product Table 1' ), 'Product Table 1' ) < 4000 Here in this example country column is the same in both tables, Add the new column and apply the below-mentioned DAX formula to it.Load the table data into the Power BI desktop, Make sure both the tables have one same column so that it will make a relationship into it.In this example, if the sold amount value is less than 4000 and the Product is B and the country column is Mexico then it should compare two tables with multiple columns and display the result as True else False.Here I have used the same product table data to compare the two tables based on the condition.Let us see how to compare multiple columns with two different tables in Power BI, Read: Power BI Add Calculated Column How to compare multiple columns in Power BI This is how to compare two tables based on the condition in Power BI. How to compare two tables in Power BI example
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |