Calculating Weekly Hours per category

[Anonymous]

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.

[Icey]

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

[FrankAT · Accepted solution]

Hi,

the measure may be (see figure):

Regards FrankAT

[Anonymous]

Hi 

The week number comes from a different table.

Will this make a differnece?

[Icey]

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.