topic Re: Calculated column - convert data type in DAX Commands and Tips

Calculated column - convert data type

domtrump — Thu, 28 Mar 2024 17:07:53 GMT

I have a table in my data model that was loaded from a query. I have a column that came over as text. I need an additional column that has this column represented as an integer. No longer have access to the original data source so can't be done in power query. I tried the following from an example in the Help but it just results in error.

Syntax

DAX

CONVERT(<Expression>, <Datatype>)

I type CONVERT(Table[MyTextColumn],INTEGER)
Error:

How can I accomplish what I need?

Re: Calculated column - convert data type

lbendlin — Thu, 28 Mar 2024 19:45:17 GMT

Cannot reproduce

Table = ADDCOLUMNS({"10"},"num",CONVERT([Value],INTEGER))

Show more of your DAX.

Re: Calculated column - convert data type

Anonymous — Tue, 02 Apr 2024 03:06:13 GMT

Hi domtrump

Thanks for the reply from lbendlin , please allow me to provide another insight:

In excel, the Syntax of Convert() function is that:

CONVERT(number,from_unit,to_unit)

Here are detailed description of this function:

CONVERT function - Microsoft Support

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.