Forum Discussion
Compare two fields to populate a new column
- Anonymous4 years ago
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!
Anonymous
Please check if it helps Solved: The column x either doesn't exist or doesn't have ... - Microsoft Power BI Community
Regards,
Ritesh