Compare the cells value

[Aden123]

There are 2 product names in the table.

How do I display the 'Comparsion' value as 'Yes' when the cell value in 'Category' is the same as 'config', and 'No' when they are different for the same product name?

Machine	Product	config	Category	Comparison
X.Y	ABC	100%	100%	Yes
X	ABC	SAMPLING	100%	No
X.Y	DEF	100%	SAMPLING	No
X	DEF	SAMPLING	SAMPLING	Yes

[Burhan_Jiru · Accepted solution]

Table.AddColumn(#"Changed Type", "Custom", each if [config] = [Category] then "Yes" else "no")

Hi,

add a custom column in power Query and place this.

Hope this helps. 

if this has solved your problem you can mark this as a solution.

[Burhan_Jiru · Accepted solution]

Table.AddColumn(#"Changed Type", "Custom", each if [config] = [Category] then "Yes" else "no")

Hi,

add a custom column in power Query and place this.

Hope this helps. 

if this has solved your problem you can mark this as a solution.

[Burhan_Jiru · Accepted solution]

or add a conditional column like this