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 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 |
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
2 Replies
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