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
Anonymous
Not applicable

Searching value in one column in another column

Hi Experts,

 

I need to search for a value of column "Assigned ID" in "Approver ID" respective of their "Requisition ID" eg

 

Requisition IDAssigned IDApprover ID
111MJ2MK1
111MJ2JK2
111MJ2MJ2
111MJ2SK4
222HJ1MJ2
222HJ1SK4
222HJ1UH6
222HJ1HJ1

 

I want my results to look like:

 

Requisition IDAssigned IDApprover IDAudit
111MJ2MJ2Found
222HJ1 Not Found

 

1 ACCEPTED SOLUTION
MatejZukovic
Resolver I
Resolver I

Hi @Anonymous ,

 

you may consider creating 2 columns :

1. Flag comparing Assigned ID & Approver ID. 

Audit_Flag = 'Table'[Assigned ID] = 'Table'[Approver ID]

2. All Requisitions IDs which contain at least 1 TRUE flag from previous column will be marked as TRUE otherwise FALSE

Audit_Result = CALCULATE(CONTAINS('Table','Table'[Audit_Flag],TRUE()),ALLEXCEPT('Table', 'Table'[Requisition ID]))

Final table will look like this:

Capture.JPG

Let us know if it helped!

Matej

 

 

View solution in original post

5 REPLIES 5
MatejZukovic
Resolver I
Resolver I

Hi @Anonymous ,

 

you may consider creating 2 columns :

1. Flag comparing Assigned ID & Approver ID. 

Audit_Flag = 'Table'[Assigned ID] = 'Table'[Approver ID]

2. All Requisitions IDs which contain at least 1 TRUE flag from previous column will be marked as TRUE otherwise FALSE

Audit_Result = CALCULATE(CONTAINS('Table','Table'[Audit_Flag],TRUE()),ALLEXCEPT('Table', 'Table'[Requisition ID]))

Final table will look like this:

Capture.JPG

Let us know if it helped!

Matej

 

 

Thanks I was looking for similar thing to look Column1 value (A) in Column2 values (A,B) in same table.

Solution: CONTAINSSTRING worked

Anonymous
Not applicable

@MatejZukovic 

Thanks for the solution and the final table loooked great. I require one more help on this, I need a table view on dashboard with one line each of requisition ID with its audit column. Just like the below table:

Requisition IDAssigned IDApprover IDAudit
111MJ2MJ2Found
222HJ1 Not Found

Hi @Anonymous ,

 

you can create one more column :

Capture.JPG

 

Then create a table in your report bringing in Requisition ID, Assigned To, and the column created above. Unselect "Other Matches" in the table through a filter.

 

 

Anonymous
Not applicable

Thanks A lot.

 

That is what i was looking for.

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors