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.
I have a table of dates and timeslots built entirely in Power Query:
The timeslots are currently 30m long just to make it easier to visulaise - eventually these will be 1 minute if feasible.
I also pull in a .csv file with the following structure:
The .csv file represents periods when a certain condition was true (the PERIOD and MONTH column are superfluous).
There will be one row per period and there can be multiple periods on any given date.
The aim is to produce somelthing like a Gannt-chart as per this post - https://community.fabric.microsoft.com/t5/Desktop/Calculate-subtotal-rows-by-column/m-p/3268562#M109... but that still has multiple row per day if there were multiple periods on that date.
Alternatively, if there is some way to simply build a timeslot table with 0 and 1 directly from my .csv file, that would be good.
Please provide sample data (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-...
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |