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

PaulDBrown's avatar
PaulDBrown
Community Champion
5 years ago

arb1782 

 

Use the Option in the ribbon to add a new conditional column and write the logic in the interface. You can select different columns.

For example:

 

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