Converting an Integer to a Text Value in Power BI
<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>