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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
smurfy12345
New Member

Comparing two values of each row from different tables

 
3 REPLIES 3
smurfy12345
New Member

Sure, the rawdata seems to be messedup while posting. What i want is For example, For this E5550 model A24 is the latest version so when i compare rawdata with WL if the version A24 then it is updated or lesser than that like A19 or something which means it is outdated.

amitchandak
Super User
Super User

@smurfy12345 , I am not able to connect the data point with what you said and what you shared. Can you share the expected output and explain with example

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

MCS_ComputerManufacturerNam MCS_ComputerModelName  BiosVersion

Dell Inc.                                       Latitude E5570                             A24

Dell Inc                                        Latitude E5570                             A21

Dell Inc.                                       Latitude E5570                             A19

This is what the rawdata table looks like 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.