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] +...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    HI steambucky

     

    Please try an ampersand  &

     

    eg.

     

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

     

     

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"