Forum Discussion
Solved
Need help with custom column formula in PowerQuery
Hi I have a table that's built by referencing another table. Within the second table I need to create a custom column ith the following logic If column X = 'xyz', then "yes" If column Y = 'x...
Hi arb1782 ,
You could use the following syntax in "Add a custom column" window.
each if [X]="xyz" then "Yes" else if [Y]="xyz" then "Yes" else "No"Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.Best Regards,
Eyelyn Qin
Hi arb1782 ,
You could use the following syntax in "Add a custom column" window.
each if [X]="xyz" then "Yes" else if [Y]="xyz" then "Yes" else "No"Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
Thanks all