Forum Discussion
Time Difference
You can still create a measure with sum/max/min, and change the to Time format.
Measure = SUM('Table (2)'[End])-SUM('Table'[Start])If you cannot make the columns in a same table, you should have a relationship between the two tables.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MH3 - So, if these are in two different tables as I suspect, then there must be a relationship between the tables that joins them correct? And I would also need to make the assumption that there is something in the visual that uniquely identifies rows in the tables in question like an ID or something. In that case, you can do something like:
Measure = DATEDIFF(MAX('Table1'[Start Date]), MAX('Table2'[End Date]),HOUR)
That is not your only option (HOUR):
https://docs.microsoft.com/en-us/dax/datediff-function-dax
If they are in the same table, then replace 'Table2' with 'Table1', you will still need something in your visual for unique row identification.
If these are columns in the same table and you would like a calculated column instead of a measure:
Measure = DATEDIFF('Table1'[Start Date], 'Table1'[End Date],HOUR)
Just FYI, you can also do the same calculation as above like this:
'Table1'[Start Date] - 'Table1'[End Date] * 24
The integer portion of a date/time column is the number of days since a certain point in time (december 30th, 1899 or something like that). The decimal portion is fractions of a day. You can get minutes 24 * 60 or seconds 24 * 60 * 60.
If this does not work or assumptions are bad please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.