Search code examples
powerbidaxm

Converting an Integer to a Text Value in Power BI

I’m creating a calculated column in a Power BI report. The calculated column concatenates integer and text columns. I tried using the below query to accomplish this, but it resulted in a syntax error.

CalculatedColumn = Number.ToText(table1.[RegionID]) & " " &  table1.[RegionName]

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?

Solution

  • Make sure you have the correct format string.

    Try this:

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