Forum Discussion

arb1782's avatar
arb1782
Helper III
5 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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