how to convert a Integer to Text value in Power BI

Question

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 

Answer 1

• you have the correct format string.

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

If you want to learn more about Power BI, then read the Power BI Tutorial. Also, enroll in Power BI training Course to become proficient in this BI tool.