The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 @Anonymous ,
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 !
User | Count |
---|---|
17 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
9 | |
8 |