Forum Discussion

AV_04's avatar
AV_04
Helper I
3 years ago
Solved

Power BI Help

Hi Team,   I have these two tables: Product Code Date Position ID Common Column A 1 6/3/2023 1 12 A-1-6/3/2023-1-12 C 3 6/4/2023 2 13 C-3-6/4/2023-3-32 S 2 6/5/2023 r...
Need Help
  • bharath_v's avatar
    bharath_v
    3 years ago

    Hi AV_04 

     

    If the columns are same in both tables, you can merge the tables based on the "Product" which seems to be unique in each table. 
    You can go to "Transform Data" -> Under Home select "Merge Queries" and select as below:

     

    This produced me the desired output as below:

    Hope this works for you!

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

     

bharath_v's avatar
bharath_v
Resolver I
3 years ago

Hi AV_04 

 

If the columns are same in both tables, you can merge the tables based on the "Product" which seems to be unique in each table. 
You can go to "Transform Data" -> Under Home select "Merge Queries" and select as below:

 

This produced me the desired output as below:

Hope this works for you!

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

 

AV_04's avatar
AV_04
Helper I
3 years ago

Hi Bharat,

Is it possible to do in DAX? The tables are updated and are of different structure now. But the common column remains the same. I just want the count of matching and non matching common column from both the tables. could you help me here?