The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
67 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
122 | |
39 | |
30 | |
24 | |
22 |