cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ankit041 Frequent Visitor
Frequent Visitor

How to round negative values

Capture.PNG

 

As you guys can see I have already applied Round up to 2 decimal place for Actual profit columns. But it seems that for some negative decimal values it is not applying and for some it is working fine. Suggest me how to round it up . e,g  (1524.4400000001) to (1524.44).

14 REPLIES 14
Super User
Super User

Re: How to round negative values

Should just be:

 

Column = ROUNDUP([Column],2)

Shouldn't matter if it is negative. You would need this wrapped around whatever your calculation is for Actual Profit.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Community Support Team
Community Support Team

Re: How to round negative values

Hi @Ankit041,

 

Have you resolved your problem? If so, would you please kindly mark the helpful reply as an answer or sharing your solution?

 

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.
Ankit041 Frequent Visitor
Frequent Visitor

Re: How to round negative values

No  the problem still persists. I have used all the know thing to resolve it but with no affect.

Super User
Super User

Re: How to round negative values

Have you set the formatting to a 2 place decimal?


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!
Ankit041 Frequent Visitor
Frequent Visitor

Re: How to round negative values

Yes I did but still the value of the highlighted ones are not changing at all

Super User
Super User

Re: How to round negative values

Can you show us the formula for that measure and the data type and formatting on it from the Modeling tab?


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!
Highlighted
Ankit041 Frequent Visitor
Frequent Visitor

Re: How to round negative values

The problem is in the Query view it is rounding up  to 2 decimal values. But as soon as I am reverting back to report view its is not getting round up..Strange isn't it.

 

Capture.PNGCapture1.PNGCapture2.PNG

Ankit041 Frequent Visitor
Frequent Visitor

Re: How to round negative values

This is the formulae Power BI is using

 

= Table.TransformColumns(#"Changed Type2",{{"Actual Profit", each Number.Round(_, 2), type number}})

 

Actual Profit is the Column Name.

Super User
Super User

Re: How to round negative values

Right, so after you load it from the query when you're back in the report, check the formatting in the Modeling tab.


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!