Forum Discussion
Solved
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. ...
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
Hi 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