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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Lookup value from one table from another

I have a large table with one of the columns as 'CID' and there are multiple rows in this table with the same CID value.

There is another table with distinct CID codes that I need to match the previous table against.

 

So, I need to add a column to the large table that says CIDmatchs with logic being, if there is a match with the lookup table value; set it to 1 else 0 so I can count all the 1s together.

 

Can someone please help me with the logic for DAX or M any any method I can use to resolve this??

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous, sounds to me like you have selected "Add Measure" instead of "Add Column"?

Just check that you have used "Add Column" and done so in the table that will hold the CID Flag.  In this case we are adding it to the CID Table.

View solution in original post

11 REPLIES 11

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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