Forum Discussion
Rounding Numbers Help
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
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