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 All,
I am looking for some help with a request ive been given.
There are a few things we are trying to do. The image atatched is a snapshot of the data i am working with:
- Create a measure that sums the total hours utilised per week, per vehicle.
- I then want to plot that in a historgram chart. The X axis would read 168 hours (total number of hours in a week). The values would be the weekly utilised hours per vehicle.
Any help would be much appreciated.
Solved! Go to Solution.
Hi @Anonymous ,
Is this problem solved?
If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If not, please let me know.
Best Regards,
Icey
Hi,
the measure may be (see figure):
Regards FrankAT
Hi
The week number comes from a different table.
Will this make a differnece?
Hi @Anonymous ,
If the two tables have the correct relationship, there is no difference.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |