Forum Discussion

Tanmaub8055's avatar
Tanmaub8055
Regular Visitor
4 years ago
Solved

Expression.Error: We cannot apply operator & to types Number and Text

Expression.Error: We cannot apply operator & to types Number and Text. Details: Operator=& Left=394838 Right=4274030 let Source = SharePoint.Files("https://sharepoint.com/PowerBiDashboards", [Api...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Tanmaub8055,

    I think this issue should be related to the 'Add custom2' steps, current you can't directly use the '&' operator to concatenate different types of values. You need to convert these values to text first:

    #"Added Custom2" = Table.AddColumn(
    #"Split Column by Delimiter2",
    "Date",
    each
        Text.From([Date.1]) & "/" & Text.From([Date.2]) & "/" & Text.From([Date.3])
)

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Tanmaub8055,

I think this issue should be related to the 'Add custom2' steps, current you can't directly use the '&' operator to concatenate different types of values. You need to convert these values to text first:

#"Added Custom2" = Table.AddColumn(
    #"Split Column by Delimiter2",
    "Date",
    each
        Text.From([Date.1]) & "/" & Text.From([Date.2]) & "/" & Text.From([Date.3])
)

Regards,

Xiaoxin Sheng