Rounding Numbers Help

[Scotteh]

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?

Days =

VAR HS = 'Transition Time'[Date End Change] - 'Transition Time'[Source Status Change Date]

VAR CS = TODAY() - 'Transition Time'[Date End Change]

RETURN

IF(ISBLANK('Transition Time'[Source Status Change Date]),CS,HS)

The Days is not part of the underlying tables, it is created from the above queries.

TIA,

Scott

[amitchandak · Accepted solution]

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

[Scotteh]

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

[Scotteh]

Nevermind, I have found it in the modelling tab!

Thank you for your help.

Scott