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 name]

City name: dataset[city name]

 

I'm trying to use

calcol=(concatenate("Country name:",dataset[country name]) , concatenate("state name:",dataset[state name]) )

but getting error

Let me know how can i do it in power bi 

 

  •  Try this one:

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

1 Reply

  • Alex_Serebr's avatar
    Alex_Serebr
    Frequent Visitor

     Try this one:

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