Forum Discussion
Difference between two times
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
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