Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
102 | |
99 | |
38 | |
37 |
User | Count |
---|---|
158 | |
125 | |
76 | |
74 | |
63 |