Forum Discussion
Rounding Numbers Help
Hi Everyone,
I've only recently started using PowerBI, but was hoping the community could help. I've looked at previous posts on rounding but they seem overly complex for what I want to achieve. I have newly created view with 'Days' which is giving me the difference between certain fields. Unfortunately the end result shows me 3 decimal places after the Day, which I'd like to round up.
Is there an easy way to do this?
TIA,
Scott
use round
round(IF(ISBLANK('Transition Time'[Source Status Change Date]),CS,HS),0)
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
3 Replies
use round
round(IF(ISBLANK('Transition Time'[Source Status Change Date]),CS,HS),0)
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on LinkedinHi amitchandak,
Thanks, that definitely round it. Is there now a simple way to remove the 4 decimal places?
e.g. 929.0000 to 929?
Sorry, I should have stated that originally also.
Scott
Nevermind, I have found it in the modelling tab!
Thank you for your help.
Scott
