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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
Lily_DS
Frequent Visitor

add new column ( true false) based on another table

Hello 

 

I have 2 tables(A , B) ,

I need to add [true , false] column to tableA

if  row in TableA same in TableB  return True

 

 

I tried this , but i got errors

 

 

= List.Contains(TableB[id], [id])

 

 

 

Thanks in advance

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi,

If you are trying to get the result in Power Query Editor, please check the below picture and the attached pbix file.

Jihwan_Kim_0-1662882595028.png

 

= Table.AddColumn(Source, "Custom", each if List.Contains(TableB[B], [A]) then true else false)

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Visit my LinkedIn page by clicking here.


Schedule a meeting with me to discuss further by clicking here.

View solution in original post

2 REPLIES 2
MahyarTF
Memorable Member
Memorable Member

Hi,

I used the List.positionof function in power query as below :

I did create the below custom column in Power query :

1- the first table (Sheet181) :

MahyarTF_0-1662883861423.png

2- Sheet180 :

MahyarTF_1-1662883881897.png

3- in Sheet181, add new Custom Column :

= Table.AddColumn(#"Changed Type", "ExistValue", each if List.PositionOf(Sheet180[Name],[#"Name "]) >= 0 then true else false)

Then use it in the visual :

MahyarTF_2-1662883945371.png

Appreciate your Kudos

Mahyartf
Jihwan_Kim
Super User
Super User

Hi,

If you are trying to get the result in Power Query Editor, please check the below picture and the attached pbix file.

Jihwan_Kim_0-1662882595028.png

 

= Table.AddColumn(Source, "Custom", each if List.Contains(TableB[B], [A]) then true else false)

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Visit my LinkedIn page by clicking here.


Schedule a meeting with me to discuss further by clicking here.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.