Forum Discussion
YoussefN
8 years agoRegular Visitor
Calculation in hours between date and time
Hi, I have a table with logging moments for service calls. I use two measures to find the first start date Date Time Created = CALCULATE(MIN(PBI_SER_Doc_ref_point[Date_Time_Registrated]);FILTER(...
- 8 years ago
Hi YoussefN
Try the DateDiff function in DAX
https://msdn.microsoft.com/en-us/library/dn802538.aspx?f=255&MSPPError=-2147217396
Try this MEASURE
MEASURE = DATEDIFF ( [Date Time Created], [Date Time Function Recovered], HOUR )
Zubair_Muhammad
8 years agoCommunity Champion
Hi YoussefN
Try the DateDiff function in DAX
https://msdn.microsoft.com/en-us/library/dn802538.aspx?f=255&MSPPError=-2147217396
Try this MEASURE
MEASURE = DATEDIFF ( [Date Time Created], [Date Time Function Recovered], HOUR )
- YoussefN8 years agoRegular Visitor