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.
Hi,
I have production data summarized in the below format.
Product Code/Location/Quantity and Production Start and End timestamps:
I have a separate Calendar table which has all the Calendar Dates and Hours.
How can I turn the data table efficiently into a format where the quantities are evenly allocated between the start_time and end_times, so that I can visualise them on an hourly chart?
Many thanks.
needs more details. Do you need this by hour? Are there any hours that need to be excluded? Weekends? holidays?
Hi, as in the original post, I have a separate Calendar table which has all the Calendar Dates and Hours. My intention is to use that on the x-axis of the output graph.
Thanks
What about the exclusions?
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |