Total Hours per Company per Professional

[EduardoVaz]

Hi all!!

I want to show the total hours per company per professional. The hours I collect in minutes which are converted to hours through a function in the database. The "Realizado" column shows the result of this conversion, and the "Realizado (h)" column is the original data in minutes, as you can see in the image below.

When I bring it to Power BI the result comes in the same way.

I want to display the total hours logged per user per company, but I am not able to present it that way, as there is no option to add up the hours.

How can I solve it?

Thanks in advance.

[Anonymous · Accepted solution]

Hi @EduardoVaz ,

Now that you have column with hour numbers, you can create a measure like this, and when this measure is put into the values of the matrix, the total will return the sum of the time.

Time =
VAR _num =
    SUM ( 'Table'[Realizado (h)] )
VAR _HOUR =
    ROUNDDOWN ( _num, 0 )
VAR _MINUTE =
    MOD ( _num, 1 )
RETURN
    TIME ( _HOUR, _MINUTE * 60, 0 )

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tackytechtom]

Hi @EduardoVaz ,

You cannot sum up the values from realisado since it has the type text "00:12". You should be able to creeate a meeasure by using the realisado (h) since this is in the format number.

Would it solve your issue if you just use the realisado (h) column instead?

Let me know 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/