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 have a table that has start and end times for calls. I need to create a column that has a time frame that the call took place in. Is this possible in Power BI desktop? Below example has it split by hour, can it also be done by quarter hour?
Example:
StartTime | Time Frame |
01/04/22 10:28 AM | 10:00:00 AM |
01/11/22 11:24 AM | 11:00:00 AM |
01/04/22 2:18 PM | 2:00:00 PM |
01/05/22 10:46 AM | 10:00:00 AM |
01/07/22 7:09 PM | 7:00:00 PM |
02/15/22 2:10 PM | 2:00:00 PM |
01/07/22 11:18 AM | 11:00:00 AM |
01/11/22 2:45 PM | 2:00:00 PM |
01/18/22 6:48 PM | 6:00:00 PM |
03/21/22 2:43 PM | 2:00:00 PM |
01/26/22 12:12 PM | 12:00:00 PM |
02/03/22 10:12 AM | 10:00:00 AM |
01/27/22 12:03 PM | 12:00:00 PM |
Solved! Go to Solution.
Hi @RobertReeves ,
I think you can try this code to create a calculated column.
Time Frame = TIME(HOUR('Table'[StartTime]),00,00)
Change the data type to Time. Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you. That worked. I appreciate the assistance.
Hi @RobertReeves ,
I think you can try this code to create a calculated column.
Time Frame = TIME(HOUR('Table'[StartTime]),00,00)
Change the data type to Time. Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |