how to convert a Integer to Text value in Power BI

sql powerbi dax m
bmsqldev picture bmsqldev · Jun 24, 2016 · Viewed 80.4k times · Source

I am creating a calculated column in existing power BI report. the calculated column concatenates integer & text columns. I tried below query which give 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 how to achieve the above scenario in power bi

Answer

Rafael Loureiro picture Rafael Loureiro · Dec 6, 2016

Try

= "Text" & Number.ToText(Number)

Related questions

How to use SQL Server stored procedures in Microsoft PowerBI?

I want to generate reports from my SQL Server tables. I have some already made stored procedures that I would like to use to generate reports from. I haven't found a way to do so. Only by rewriting the queries. …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More