Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm looking to round time to the nearest minut and is using the following formula but when converted to time the time is off.
CloseTime = mround('5100'[Close Time], time( PM1,1,0)
I presume it is something wroing with the 1,0
Data
Close Time
10:11:25 PM where I want it to show 10:12:00 PM
Solved! Go to Solution.
Hi,
try this
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Hi @MdJ83 ,
Create a new column
CloseTime = CEILING('5100'[Close Time],"0:01")
Mark it as a solution if it answers your question. Kudos are always appreciated.
Thanks
Hi,
try this
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
48 | |
24 | |
20 | |
14 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |