Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

New Member

Solution for data comparision

Hello all, 

I need to find a solution for below issue:

  • We are having 2 tables, in the first table there are 3 attributes (Hostname, Key, Value) and in the second table there are 4 attributes (Hostname, Date, Key, Value)
  • We are merging the above two mentioned tables keeping Key as a primary key.
  • And then, we are comparing Value attributes of both tables that they are the same or not.
  • In the first table, we are getting in one row Value attributes Like { Apple,mango }, and in the second table, we are getting Value attributes like { Apple } or { mango }.
  • We are comparing Value attributes on the bases of, if one value is the same for both tables then we consider that they are same.



Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.