The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello,
I have timestamps of when drivers accepted a job and completed a job. However I am needing to create a chart with 15 minute increments showing the total number of drivers that were actively on a job. Basically any time between the start and finish of a job I would want to see that driver counted on my chart. Any tips for doing this?
From the Accepted Time to Completed time I would expect this driver to be counted as a working driver on the chart for 5:30, 5:45, 6:00. But I dont not know how to achieve this with just timestamps.
Example chart:
Thank you!
Solved! Go to Solution.
Hi @AndrewWstry
You can create a table
Sample data
Then you can create a table
Table 3 = GENERATESERIES(MAX('Table'[Column2]) , MAX('Table'[Column1]) , 1/24/2/2)
Output
And you can refer to the following link.
Creating a List of Numbers or Dates in Power BI using GenerateSeries Function in DAX - RADACAD
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.
Hi @AndrewWstry
You can create a table
Sample data
Then you can create a table
Table 3 = GENERATESERIES(MAX('Table'[Column2]) , MAX('Table'[Column1]) , 1/24/2/2)
Output
And you can refer to the following link.
Creating a List of Numbers or Dates in Power BI using GenerateSeries Function in DAX - RADACAD
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
94 | |
94 | |
88 | |
69 | |
65 |
User | Count |
---|---|
232 | |
128 | |
116 | |
82 | |
82 |