cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
marcos_osorio
Helper II
Helper II

Remove Scientific notation in measure

Hi, i have a measure that substracs two other measures. The database is in SQL, but the problem is that in a column instead of appear 0 it appears in scientific notation, like 3e-11, i tried ROUND, TRUNC for the measure but nothing seems to work.

How can I solve this?

 

Thank you very much.

3 ACCEPTED SOLUTIONS
Arul
Post Patron
Post Patron

Hi @marcos_osorio ,

Can you please check the datatype and let me know.

 

Thanks & regards,

-Arul

 

View solution in original post

v-yulgu-msft
Microsoft
Microsoft

Hi @marcos_osorio ,

 

After loading data into desktop, please change the data type to Decimal, and set decimal places to 11 or above if you want to display the whole value. 

1.PNG

 

If you only want to round the value as a integer, set decimal place to 0.

2.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

MelSta86
Frequent Visitor

Did you ever find a solution? I am struggling with the same problem. It works when I change the fomar to currency but I would like to keep the decimal and just round it. 

View solution in original post

5 REPLIES 5
MelSta86
Frequent Visitor

Did you ever find a solution? I am struggling with the same problem. It works when I change the fomar to currency but I would like to keep the decimal and just round it. 

View solution in original post

v-yulgu-msft
Microsoft
Microsoft

Hi @marcos_osorio ,

 

After loading data into desktop, please change the data type to Decimal, and set decimal places to 11 or above if you want to display the whole value. 

1.PNG

 

If you only want to round the value as a integer, set decimal place to 0.

2.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Please check for Data Display unit as well. It will remain scientific if Display unit is not selected Auto...

Arul
Post Patron
Post Patron

Hi @marcos_osorio ,

Can you please check the datatype and let me know.

 

Thanks & regards,

-Arul

 

View solution in original post

Now it's decimal. 

If i change it to currency the problem appears to solve, but i would like to keep is as decimal.

Thank you very much!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.