0 votes
1 view
in BI by (17.6k points)

I am creating a calculated column in the existing power BI report. the calculated column concatenates integer & text columns. I tried below query which gives syntax error to me,

= Number.ToText(table1.[RegionID]) & " " & table1.[RegionName]

I tried some other conversion methods which were not a success. Someone, please guide me on how to achieve the above scenario in power bi 

1 Answer

0 votes
by (47.2k points)
  • you have the correct format string.

FORMAT(table1.[RegionID], "#") & " " &  table1.[RegionName]

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers !