Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am stuck with my Matrix.
What works for me now :
I have timestamps.
Those timestamps are for a specific date, and linked to a specific Service Order.
There are different types of timestamps (travel time, waiting time,...)
So for each workday , i want to show each SO.
And for those so's, show in different columns the available timestamps.
and then for each total (day level and total level) the sum.
My timestamps have mintues to show how long they took.
When I have that column as whole number, it works perfect, the totals work and give a clear result.
However, Business want to show the data as Time (hh:mm).
When changing the field to time, I cant have a sum, only earliest , latest and count.
Is there another way or visual too give me the correct result?
Thanks in advance!
Solved! Go to Solution.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
hi @Anonymous
you don't need to change the field to time, just use a measure to format the result as Time (hh:mm).
https://docs.microsoft.com/en-us/dax/format-function-dax
and your could also format the result as custom format.
if you still have the problem, please share a simple sample pbix file and your expected output.
Regards,
Lin
Thank you for answer, it ahs pushed me into the correct solution!
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Yes!
This is perfect!
I added some extra code for removing empty results from the list.
Thank you very much!
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |