Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hi everyone,
I have an data output in my sql table in number format, when trying to calcuate the differentiate output comes in number format but output required is below.
11.35 to 11:21 and should rounddown to 11:00
11.65 to 11:39 and should rounddown to 11:30
12:00 to 12:00 and should not rounddown to 12:00
Solved! Go to Solution.
Hello @askspepsi ,
If I got your logic correctly, try the following forms in new columns:
Half hour =
ROUND('Table'[Value] / 24 * 48,0) / 48
Desired Output =
IF(
MINUTE('Table'[Value] / 24) <= 30 ,
ROUND('Table'[Value] , 0 ) / 24 ,
ROUND('Table'[Value] / 24 * 48 , 0 ) / 48
)
Greetings FrankAT
Hello @askspepsi ,
If I got your logic correctly, try the following forms in new columns:
Half hour =
ROUND('Table'[Value] / 24 * 48,0) / 48
Desired Output =
IF(
MINUTE('Table'[Value] / 24) <= 30 ,
ROUND('Table'[Value] , 0 ) / 24 ,
ROUND('Table'[Value] / 24 * 48 , 0 ) / 48
)
Greetings FrankAT
sorry for the late reply,
Thanks for the update. this is the extact output i required.
regards
askspepsi
@askspepsi , check if you can create a column suggested in this post
https://community.powerbi.com/t5/Desktop/Round-up-time-to-next-hour/td-p/701404
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
60 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |