Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guyz,
I am facing issue while converting data type decimal to whole number. when it converted it, it is not showing correct information for example there are 2 columns of decimal no and i added 1 new column in my report adding those 2 columns and change th datatype as whole no but it is giving incorrect information.
1st column (datatype decimal) 2 Column(datatype decimal) New Col(1st col+2nd Clol)(datatype Whole number)
40 40.5 80
It should be 81 . i have also changed the datatype from edit query also but problem still the same. please help
Solved! Go to Solution.
Hi @pprakash ,
The unexpected total value might be related to the source data of column2. You can see the difference from below screenshot.
To deal with this behavior, you can add a calculated column with below DAX:
Column = ROUND(Table1[Column1],1)+ROUND(Table1[Column2],1)
Best regards,
Yuliana Gu
Hi @pprakash ,
The unexpected total value might be related to the source data of column2. You can see the difference from below screenshot.
To deal with this behavior, you can add a calculated column with below DAX:
Column = ROUND(Table1[Column1],1)+ROUND(Table1[Column2],1)
Best regards,
Yuliana Gu
Hi @pprakash
I did the same thing and got 81.
Could you share the file via dropbox or something so I can take a closer look?
I made them 2 decimal places to make sure it was 4.5 and not 4.499999 and rounded up as that might make the difference.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |