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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
bblackwell3
Helper I
Helper I

Match and Count values from two different columns and two different tables

Hey all.  I am attempting to find matching text values in two different columns in two related tables in my model. Then, get a count of those "matches" . CPlatform and TPlatform is where I need to find and count the matches
Lets say table 1 is called "Full Data"

IDCPlatform
34578Que
36678Azure
22480Azure

 

table 2 is called "Platform Data"

IDTPlatform
34578Que
36678Azure
22480Azure


I would like have this new column be an actual column in one of the above tables

1 REPLY 1
bblackwell3
Helper I
Helper I

FYI ID and the Platform are two seperate columns above

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.