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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Compare two fields to populate a new column

I want to do a simple thing...

I want to compare two columns on my report.  If they're the same, I want a new column that says "Yes".

(I'm trying to see if comments were entered by an employee or his supervisor).

 

This doesn't work:

Column = if([CreatedByUser] = RELATED('Workers(2)'[User]), "Yes")
 
The error is "The column 'Workers(2)[User]' either doesn't exist or doesn't have a relationship to any table available in the current context."
So what's the deal?  Do the two tables have to be directly linked?  I can't do that...
These snips show the two fields that I'm trying to compare:
 
adraus_0-1657903768956.png

 

adraus_1-1657903816607.png

 

adraus_2-1657904648555.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

I very much appreciate the assistance from users on this forum!  I found that the solution for my situation was that I needed to do more in Power Query, rather than expecting to do column comparisons in the service.

 

I first did a 'merge queries', bringing the two userid fields into one merged table.  From there, I added a custom column using an IF statement, populating my new column with data from the existing 'comments' column only if the two userIDs were different.  If they were the same, I put "remove" into the new column, instead of the comments.  Then, in a next step, I filtered rows and removed all rows containing the string "remove".

 

I've got to remember that Power Query is where all the action is.

 

Many thanks!

View solution in original post

7 REPLIES 7
Anonymous
Not applicable

I very much appreciate the assistance from users on this forum!  I found that the solution for my situation was that I needed to do more in Power Query, rather than expecting to do column comparisons in the service.

 

I first did a 'merge queries', bringing the two userid fields into one merged table.  From there, I added a custom column using an IF statement, populating my new column with data from the existing 'comments' column only if the two userIDs were different.  If they were the same, I put "remove" into the new column, instead of the comments.  Then, in a next step, I filtered rows and removed all rows containing the string "remove".

 

I've got to remember that Power Query is where all the action is.

 

Many thanks!

SpartaBI
Community Champion
Community Champion

Anonymous
Not applicable

I don't understand how LOOKUPVALUE would help.  I already have both fields on my report.  I just want to compare the two fields and, if they are the same, leave the new column blank.  If they are different, populate the new column.

 

adraus_0-1657916610376.png

 

Measure:

isSame = 

IF(MAX(TableName[User])=MAX(TableName[CreateByUser]),"YES","NO")
Anonymous
Not applicable

I had hopes with the MAX function!  but everything is coming up "NO":

 

adraus_0-1657933130750.png

I did a merge of queries to get my two "user" fields into the same table.  In the end, I actually want to put the contents of a field from another table (comments) into my new column, rather than yes/no, based on whether the two users are the same.

If those 2 are measures, try if(measure1=measure2)

Without max function.

 

 

ribisht17
Community Champion
Community Champion

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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

Top Kudoed Authors