Forum Discussion
Assign value (text) based on time range
Hello, This is a two part question: Part 1: change time to 24-hour format. Currently the date format is looking like this: 0:00:00 AM 4:00:00 AM 10:00:00 AM 17:00:00 PM 19:00:00 PM ...
Hi Anonymous
Nolock 's solution should be helpful.
If your second table has a structure as below
Early AM: 0:00:00 and 7:00:00
You could convert time range into a list, so that you could get a DIM table called "Peak_Hour_DIM" as Nolock provided.
https://community.powerbi.com/t5/Desktop/Convert-date-ranges-into-list-of-dates/td-p/129418
If it is not sloved, please let me know.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.