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.
Lets say, I have data with different charge stations used for last 60 days with start time and end time. I also created two calculated tables "DimDate" with dates, week, day and another table "time" which has two columns "time start" and "time end" to make 1 hour time interval each row. How to proceed with these to find utilization of different stations (percentage over time). Kindly help!
For instance, it is the dataset (sample). The charge port id column has same id several times used in last 60 days. I want to find the occupancy (percentage over time) where y axis will show percentage of occupancy and x axis different charge ids in the line chart.
I have created "time" table which shows all time hourly intervals
Another table "CharginDataReshaped" was created which contains rows for each charge Id & hourly interval during which that charge id is active. When I create a measure called
hi @Anonymous
try to bring more context, e.g. is %occupancy a measure? You mentioned three tables, how are they related?
Yes, Occupancy is measure. Our main dataset is charging data (first one). I created next two tables to make a modified table with hourly interval on specific dates during which charge ids were active. Let me know if you have any alternative way? Thanks
hi @Anonymous
it would be easier for all, if you could also post some sample data.
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
35 | |
32 | |
18 | |
18 |