Forum Discussion
Compare two fields to populate a new column
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!
Community ChampionAnonymous you can use LOOKUPVALUE:
https://www.youtube.com/watch?v=XTkrNdU6jWs
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI
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.
vapid128Solution Specialist
Measure:
isSame =
IF(MAX(TableName[User])=MAX(TableName[CreateByUser]),"YES","NO")I had hopes with the MAX function! but everything is coming up "NO":
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.