Forum Discussion
john121
3 years agoFrequent Visitor
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_SerebrFrequent Visitor
Try this one:
calcol = "Country: " & 'Table'[Country] & UNICHAR(10) & "State: " & 'Table'[State] & UNICHAR(10) & "City: " & 'Table'[City]