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.
Hey Guys,
So I know that in a calculated column you can use a function called generate series, so if you put in values 1, 5. This will count the values in increments by 1(by default). so the values in the calculated column would look like 1, 2, 3, 4, 5.
I was thinking if it's possible to do that between two time data type columns. Or if there's another way to do this can anyone help?
I want a calculated column that counts the time between 9am to 5pm in hour increments.
So I was thinking something like generateseries (incidents[SLA Start Time], incidents[SLA finish time])
not all hours are going to be same value, this will change, which is why I was thinking if there's a way to use the columns instead of a single value like (9, 5)
Hi @GenericUser1,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
Hi @GenericUser1,
Based on my test, you could refer to below bolg:
Quick DAX: Use GENERATESERIES to create Time buckets
Hope it could help you.
Regards,
Daniel He
Not exactly sorry, with the blog it looks like the values have to be put in manually. I was hoping if there was some way of creating a generateseries between two columns that would do that automatically, but the way I'm thinking about this could be wrong.
what i was hoping as a result would be, for example, if this was the table:
type of hours start type of hours end generateseries column
9am 5pm 9, 10, 11, 12, 1, 2, 3, 4, 5
7pm 7pm 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19
There a lot of hours that are flexible depending on the helpdesk service provided and what hours count in a contract signed by a customer. Sometimes this will need to be updated and I don't think I have time to keep doing this manually, do you get what I mean?
thanks,
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |