Cant use whole number data type

[nh27]

Hi All,

I have a column in a table that whenever I convert to a number it puts some into scientific notation. I can't keep it as "ABC123" data type as I need to create some DAX measures off this column.

Anyone know why this is happening and how to fix it?

Thank you

[v-jingzhang]

Hi @nh27 

Just keep it in whole number data type. This will not affect the result when it's used in DAX expressions. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Anonymous]

It's just being represented that way. The real number is what's in the box: 5002805000749.

--Nate