Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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:
Solved! Go to Solution.
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!
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!
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.
Measure:
isSame =
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.
If those 2 are measures, try if(measure1=measure2)
Without max function.
@Anonymous
Please check if it helps Solved: The column x either doesn't exist or doesn't have ... - Microsoft Power BI Community
Regards,
Ritesh
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
8 |
User | Count |
---|---|
31 | |
27 | |
15 | |
13 | |
10 |