CODEWITHSUNDEEP
timepowerbidax
Cheries
Cheries

Reputation: 892

How to calculate total time in hour using DAX?

I have to table, start and end with time as the data, I want to calculate the total hour from start to end.

I tried this but it does not return hour, it returns date and the date also same in the column:

Column = SUM('Data'[Finish Date])-SUM('Data'[Start Date])*24-12

Anyone can give me idea please. Thank you so much

Upvotes: 0

Views: 331

Answers (1)

Peter
Peter

Reputation: 12325

Read the docs: https://learn.microsoft.com/en-us/dax/datediff-function-dax

Column = DATEDIFF('Data'[Start Date], 'Data'[Finish Date], HOUR)

Upvotes: 2

Related Questions