title: Converting an Integer to a Text Value in Power BI
body: <p>I’m creating a <strong>calculated column</strong> in a Power BI report. The calculated column concatenates <strong>integer</strong> and <strong>text</strong> columns. I tried using the below query to accomplish this, but it resulted in a syntax error.</p>
  <pre><code>CalculatedColumn = Number.ToText(table1.[RegionID]) &amp; &quot; &quot; &amp;  table1.[RegionName]
  </code></pre>
  <p>I tried some other conversion methods also, which were not successful. Could someone please guide me on how one could achieve the above objective in Power BI?</p>