How to convert a Integer to Text value in Power BI

Question

I am creating a calculated column in existing power BI report. the calculated column concatenates integer & text columns. I tried below query which give 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 how to achieve the above scenario in power bi

Answer 1

Make sure you have the correct format string.

Try this:

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

Hope this is helpful. If you are interested in learning Power BI then check out Power BI Course now!