topic Re: Convert string to number in DAX Function in DAX Commands and Tips

Convert string to number in DAX Function

qsong — Tue, 08 Sep 2020 12:26:22 GMT

Hello Community,

I connected to the source data through the online mode of the AAS model in Power BI, so I am not able to change formats of the datasets using the conventional ways (power query, for instance). Before doing the calculation, I need to convert the string to numerical value. For that, I used "Format", "value", or "convert", none of them worked for me because I cannot find the column in those formulas. For example, I have a string column "201908" and want to convert a value of 201908. Thank you.

Re: Convert string to number in DAX Function

Greg_Deckler — Tue, 08 Sep 2020 12:32:06 GMT

qsong - Try [Column] * 1

Re: Convert string to number in DAX Function

qsong — Tue, 08 Sep 2020 12:39:10 GMT

Hi Greg_Deckler,

Thank you for your suggestion.

I cannot find the column except I have to add something like sum before the column; However, column has a string value, so sum does not work on the case.

Best, Qianru

Re: Convert string to number in DAX Function

Anonymous — Tue, 08 Sep 2020 13:16:45 GMT

Hi qsong ,

Can you share the screenshot of your table and the column you want to convert.

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Re: Convert string to number in DAX Function

qsong — Tue, 08 Sep 2020 13:45:08 GMT

Hi Anonymous,

I have a string column called calendar_month_key, and I want to convert it to be a numerical column called PP. As I described the background before, I am not able to do the format conversion in power query or by creating a calculated column because of the particular source connection.

Currently, I am using the conditional statement for the conversion which consumes a lot of memory. So I cannot have enough space for further calculation.

Thank you.

Re: Convert string to number in DAX Function

amitchandak — Tue, 08 Sep 2020 13:49:16 GMT

qsong , are you using live connection? Otherwise, you can simply change the data type to the number and it should work as long as all values in the column are number

Re: Convert string to number in DAX Function

qsong — Tue, 08 Sep 2020 13:55:30 GMT

I am using the live connection. So I cannot use power query to make the change.

Re: Convert string to number in DAX Function

Greg_Deckler — Tue, 08 Sep 2020 14:24:29 GMT

qsong - Use MAX or MIN

Re: Convert string to number in DAX Function

qsong — Tue, 08 Sep 2020 16:15:35 GMT

Finally I used VALUE(MAX()) to refer the column names, and it works for me.

Thank you.

Re: Convert string to number in DAX Function

Anonymous — Mon, 14 Mar 2022 19:24:22 GMT

Hi Greg,

I need to convert 123-45-789-0 is kind of string format data to number format ,could you please help me .

I need to logic to get additional values result

For example,

AI Col-A Col-B Result

A 123. 123. Equal

A 123. Extra

I need to get extra for same document A