Back

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

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

30.5k questions

32.5k answers

500 comments

108k users

Browse Categories

...