Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculated Column Dax variable value being rounded

I have a calculated Column that takes 5259 / 3753900 = 0.001400943 However this is being rounded to 0.0014 even when adding extra decimal places it goes to 0.0014000. Here is my dax, ive also gone in...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    i found the issue was with this, when this column was a decimal number it would go back far past 4 decimals, after switching to fixed decimal number currency capped at 4 places.

    Top Row Example: 0.4738 actual value

     

    Top Row Example: 0.473840133 actual value

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi Anonymous ,

 

Based on your description, I have created a simple sample:

After my test, it works fine in my side:

Could you please provide more details about your table and your problem such as:

What is the Version of your Desktop?

What is your data source?

What is the connection mode?

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

 

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

 

Best Regards,

Jianbo Li

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi, thanks for the reply i am connected to azure storage, i created an export from azure and their costs seem to be capped at 4 decimal places, i can only assume this then carrys through when im doing the calculations