Forum Discussion

steambucky's avatar
steambucky
Icon for Helper III rankHelper III
8 years ago
Solved

Issues "adding" text together.

I am wanting to add a column with some text and I am getting this error:

 

 

local_govt_nm is not numbers -  its formated as text. Any ideas?

 

Mapname = 'Combined tables'[local_govt_nm] +"Queensland,Australia"

Need Help

1 Reply

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    HI steambucky

     

    Please try an ampersand  &

     

    eg.

     

    Mapname = 'Combined tables'[local_govt_nm] & " Queensland,Australia"