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

arb1782's avatar
arb1782
Helper III
5 years ago

Ah, I didn't spot that before, thanks! I've set it up as is following:

 

If column x CONTAINS 'xyz' then yes

OR if column y is equal to 'xyz' then yes

Otherwise No

 

Mhy remaining problem is that when column x is null, PBI returns error instead of No. Any ideas how to rectify this? There doesn't appear to be 'isnull' in the available criteria.

arb1782's avatar
arb1782
Helper III
5 years ago

Any further thoughts on my reply PaulDBrown