Skip to main content
cancel
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.

Reply
ankitchauhan26
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.

 

0 REPLIES 0

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

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.