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.
Hello Good day! I have the following situation that I do not know how to address:
1-I have a column where the hours of entry are recorded called 'time entry'
2 - from the column of 'time entry' I want to create another column where I take the 'Time of entry' and group it in another column 'grouping Time' in the following way example:
-if 'time entry' is for example between 8:00 and 8:29 that brings me to the column 'group Time' 8:00
-if 'time entry' is for example between 8:30 and 9:00 that brings me to the column 'group Time' 9:00
-if 'time entry' is for example between 9:00 and 9:29 that brings me to the column 'group Time' 9:00
-if 'time entry' is for example between 9:30 and 10:00 that brings me to the column 'group Time' 10:00 and so on with the hours that I register in the column 'time entry'.
it is possible to create this condition in some way
It would help me a lot!!!!!
Solved! Go to Solution.
In that case divide the result of formula by 24 and change type to Time
Thank you very much for responding shortly!!!
I tell him that the solution works with the formula that I give myself, but I need to adjust it so that the time is displayed in this way hh:mm (example: 8:00) but it only shows me the Time in a single digit as shown in the attached image.
Hi,
try to use next formula for new calculated column:
Thank you very much for responding shortly!!!
I tell him that the solution works with the formula that I give myself, but I need to adjust it so that the time is displayed in this way hh:mm (example: 8:00) but it only shows me the Time in a single digit as shown in the attached image.
In that case divide the result of formula by 24 and change type to Time
Thankful! your response to worked wonders!
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |