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.
Hi,
I have a date/time stamp in this format
11/21/2016 5:03:18 AM |
I want to have a column which says that this time is between 5 and 6 am. How do I do this ? Please help. I am trying to create hour by hour table.
Solved! Go to Solution.
Hi @Abhi92,
According to your description above, I have made a sample for your reference.
I assume you have a table called "Table1" like below.
Then you should be able to use the formula below to create a calculate column to get the time range.
Range = IF ( HOUR ( Table1[DateTime] ) < 12, HOUR ( Table1[DateTime] ) & "am" & "-" & HOUR ( Table1[DateTime] ) + 1 & "am", HOUR ( Table1[DateTime] ) - 12 & "pm" & "-" & HOUR ( Table1[DateTime] ) - 11 & "pm" )
Regards
I can convert the date/time to time but still I want to have an hourly range column. For example: 1am to 2am,2am to 3am etc..This way I can see how many parts were made for each time range. Also, I want to show the visual in a table format
Range Net pieces
1am-2am 50
2am-3am 100
Something like this.
Hi @Abhi92,
According to your description above, I have made a sample for your reference.
I assume you have a table called "Table1" like below.
Then you should be able to use the formula below to create a calculate column to get the time range.
Range = IF ( HOUR ( Table1[DateTime] ) < 12, HOUR ( Table1[DateTime] ) & "am" & "-" & HOUR ( Table1[DateTime] ) + 1 & "am", HOUR ( Table1[DateTime] ) - 12 & "pm" & "-" & HOUR ( Table1[DateTime] ) - 11 & "pm" )
Regards
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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |