Forum Discussion

New2PowerBI's avatar
New2PowerBI
Helper III
9 years ago

Combining Columns

I searched through this community and found the following formula for a new column:

 

Text.From([Column) & Text.From([Column2]) & Text.From([Column3])

 

I used it and it works great!  However, if the column has either null or number values, it errors out.  How can I overcome this?

Need Help

5 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi New2PowerBI,

     

    According your description above, I have tested it with the latest version(2.48.4792.721 64-bit (July 2017)) of Power BI Desktop on my environment. The formula works all fine without any issue, even when the column has either null or number values.

     

     

    What's the error? Could you post here? It's better that you could also share a sample pbix file which can reproduce the issue. So that we can better assist on it. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:

     

    Regards

    • New2PowerBI's avatar
      New2PowerBI
      Helper III
      9 years ago

      Here is what error I get:

       

       

       Here is the updated one:

      = Table.AddColumn(#"Changed Type6", "PMSearchData", each [PMNUM]&" , "&[DESCRIPTION]&"   ,   "&[JPNUM]&"   ,   "&[USEFREQUENCY]&"   ,   "&[FEQUNIT]&"   ,   "&[ROUTE])

       

      I have no issues if I do just 3 items.  In this case, I added three more fields and I received the error.  Not sure if it has to do with numbers and/or null values now, maybe it's more tied to the number of columns I'm trying to pull in versus what is in the column?

       

      • MarcelBeug's avatar
        MarcelBeug
        Community Champion
        9 years ago

        According to your initial information, I would expect that your code would look like:

         

        = Table.AddColumn(#"Changed Type6", "PMSearchData", each Text.From([PMNUM])&" , "&Text.From([DESCRIPTION])&"   ,   "&Text.From([JPNUM])&"   ,   "&Text.From([USEFREQUENCY])&"   ,   "&Text.From([FEQUNIT])&"   ,   "&Text.From([ROUTE]))