The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Community, Thanks for answering questions in here. Your posts have helped me the past!
I want to calculate the difference between two times and then sum this info in a matrix. I have used the forumla below
Solved! Go to Solution.
try this new measure that uses the one you already have
Time Diff TOT =
SUMX ( SUMMARIZE ( Table1, Table1[Col1], Table1[Col2] ), [Time Diff] )
Table1[Col1], Table1[Col2] are the fields you ave in rows and columns in your matrix visual. You'll probably want to convert te result to minutes; as type time it will roll over above 24 hours
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
I do not understand what you are trying to show with the matrix visuals. What works? What doesn't?
When I talked about converting to minutes I wasn't referring to using MINUTE() but to multiplying the result by 24*60
Perhaps you can leave it as time if you know the total won¡t go above 24 hours
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
The intent behind the data is to deterine the length of an event in minutes and hours. I figured the best way to do this is calculated the difference between the beginning of an event and the end of the event.
I think the problem is with my data. As noted above, if unfiltered, the table summed correctly. And, upon experiment now, the table sums correctly on a different filter selection.
Your solution was a good one.
Thank you very much for your help!
I do not understand what you are trying to show with the matrix visuals. What works? What doesn't?
When I talked about converting to minutes I wasn't referring to using MINUTE() but to multiplying the result by 24*60
Perhaps you can leave it as time if you know the total won¡t go above 24 hours
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
I am not sure that this helps. See images. I wonder if this is a filtering issue. The table/matrix correctly sums, but does not if filtered.
Hmmm...
try this new measure that uses the one you already have
Time Diff TOT =
SUMX ( SUMMARIZE ( Table1, Table1[Col1], Table1[Col2] ), [Time Diff] )
Table1[Col1], Table1[Col2] are the fields you ave in rows and columns in your matrix visual. You'll probably want to convert te result to minutes; as type time it will roll over above 24 hours
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers