March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
Solved! Go to 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:
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.
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:
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.
Any suggestions please?
Sure thing, use Table.ColumnNames to retrieve header names of a table.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
What would the full formula look like? I'm struggling to put it together.
Thanks.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |