Forum Discussion
kmilarov
Helper II
Helper IIVisual - distributions / scattered
Hi Guys, I wan to visualise the disctribution of available number of cars in the garage during the nightstop - starting of arrival and departure times. For example - number of available cars per ev...
amitchandak
Super User
Super Userkmilarov , You have create a date table and merge it with time table of every 15 Mins
Power Query- List.Times- Create Time Table: https://youtu.be/-pxMpTdnTVc
Date Table - https://youtu.be/so_A22HXbwM
Power Query cross Join - https://youtu.be/7MvROGObBYk
or use
List.DateTimes- https://youtu.be/3UBxsIvlcRQ
Then use the same approach as between dates
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
kmilarovThank you amitchandak . I created the Date/Time table with 15 mins intervals, but cannot make the data /cars distribution within the times. The Linked above does not help. So, I need to have the sum/total available Cards per every 15 mins interval. But cannot make it..