Sum of Duration [hh:mm] format

[Anonymous]

Hi,

I'm a novice on Power BI (previous user of Tableau were I found the solution) and I wanna summarize the duration on hh:mm.

I received this morning some suggestions but I haven't found a solution so far.

Unfortunately I pressed the button to accept the solution instead of reply in the morning and the colleague who helped me with suggestions did not answer me after accepting it. I do not know how to make it still unsolved. 

The idea is that I have an excel file with the time (duration) per activity spent by some employee.

I wanna aggregate the time spent by employee per activity, month, weeks and days.

I was trying some DAX formulas but still not found the correct one.

Please find below my file.

The column Timp(h) is the one that I talking about.

Thanks in advance.

https://drive.google.com/file/d/1U-qXe3B01zKuhcQ37vLWUibfJVDumTbh/view?usp=sharing 

[mahoneypat]

I looked at your file.  Since you have a Date column in your data, you can just create a simple DAX date table that has columns for Months, weeks, days. You then make a relationship between that new Date table and your data table on the date column.  You can then sum your Timp(h) column in a measure and analyze by month, week, day, etc.

Please see this link on making a simple Date table - https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Anonymous]

I can't access the file from my workplace, unfortunately, but I can tell you that such problems have been solved on these forums countless times... You just have to look for the right post.

Best
D