I am new to PowerBI, I have a table containing 4 columns equipmentName, equimentStatus (enumeration), equipment in use (binary), and start and endtime (date). the objective is to create a table to track the status of the equipment on an hourly basis per day (the table will have 24 columns representing each hour of the day and the rows represent the list of the equipment, how to populate the table with the status based on the start and end time. the end goal is to obtain a heatmap table to display the status of the equipment hourly during a day based on the events table. what is the best approach?
Thanks in advance for your support.
Solved! Go to Solution.
Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
|CCA04||En panne||8/27/2022 10:00:00 AM||8/27/2022 12:00:00 PM|
|CCA04||Disponible||8/26/2022 12:00:00 AM||8/27/2022 10:00:00 AM|
|CCA04||Disponible||8/27/2022 12:00:00 PM||9/1/2022 12:00:00 AM|
|CNA6||En panne||8/27/2022 8:00:00 AM||8/27/2022 12:00:00 PM|
|CNA6||Disponible||8/26/2022 12:00:00 AM||8/27/2022 8:00:00 AM|
|CNA6||Disponible||8/27/2022 12:00:00 PM||9/1/2022 12:00:00 AM|