Forum Discussion

john121's avatar
john121
Frequent Visitor
3 years ago
Solved

Refer multiple columns in a single calculated column

I want to create a single calculated column having multiple columns and their respective text string  and display them in a card like: Country name: dataset[country name] State name: dataset[State ...
Tips and Tricks
  • Alex_Serebr's avatar
    Alex_Serebr
    3 years ago

     Try this one:

    calcol = "Country: " & 'Table'[Country] & UNICHAR(10) & "State: " & 'Table'[State] & UNICHAR(10) & "City: " & 'Table'[City]
Alex_Serebr's avatar
Alex_Serebr
Frequent Visitor
3 years ago

 Try this one:

calcol = "Country: " & 'Table'[Country] & UNICHAR(10) & "State: " & 'Table'[State] & UNICHAR(10) & "City: " & 'Table'[City]