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.
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.
Dear Sir Anonymous amitchandak Greg_Deckler
I have used this Formula
Time DF = SUM('Log Header'[EndTime])-SUM('Log Header'[StartTime])
and my Table Structure is this:
when I used the formula in the viusalization it shows me bigger values
Filter is for HOTEL DAVOS, and the Table isSorted for Hotel Davos as Well
, is it correct or worng I can't verify it please help!
MH3 , Try like
Time DF = sumx('Log Header',('Log Header'[EndTime])-('Log Header'[StartTime])
MH3 - If you are referring to the Total, it's a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
