Forum Discussion
Solved
Compare the cells value
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 prod...
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.
or add a conditional column like this
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.
or add a conditional column like this