PQ M code: If the text in cell/row equals the text in the column header then replace it with "yes"

[Anonymous]

Hi there,

Hope someone would be able to help with this

I need to find a formula in power query m code to do the following:

if the text in the cell/row in the column matches the text in the column header then return "yes" otherwise return "no"

This is what the column could look like:

Is this possible?

Many thanks.

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

According to your requirement, I think you can simply use the “unpiovit columns” and M language to achieve your requirement, you can go to the Power query and follow my steps:

1. Click on the column and select “unpiovit columns”:

2. Create a custom column like this:

3. Remove the [Attribute] column:

4. Rename the [Name] column to its original name:

Then click on “Close and apply”, you can get what you want.

You can download my test pbix file below.

Thank you!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Any suggestions please?

[CNENFRNL]

Sure thing, use Table.ColumnNames to retrieve header names of a table.

[Anonymous]

What would the full formula look like? I'm struggling to put it together. 

Thanks.