Forum Discussion

vsolanon's avatar
vsolanon
Frequent Visitor
6 years ago
Solved

Power Query combining NULL values

Hi Experts, I am creating my fist PowerBi which is linked to SharePoint lists. I have a column within the SP List named "Author" which is a Person column. Due to this, when I changed the properties ...
Need Help
Tips and Tricks
  • edhans's avatar
    edhans
    6 years ago

    Use the following logic in Power Query:

     

     

    = [Column1] & (if [Custom] = null then "" else [Custom])

     

     

     

    It is critical you wrap the if/then/else construct in parentheses, or you'll get an error about a literal being expected. This will return the entire if/then/else as a literal, then allow you to concatenate with your other column.

     

    Then mark that new column as text, and bring it into Power BI's DAX model.