Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
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]

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. 

Related questions

Browse Categories