Forum Discussion

MYDATASTORY's avatar
MYDATASTORY
Icon for Resolver I rankResolver I
5 years ago
Solved

DAX Time calculation between two timestamp

Hi, Kindly advice with actual Dax formulae to calculate the time difference. If you're able to provide a sample of DAX based on below dammy data will be great. The data will be presented in tabula...
Need Help
Show and Tell
  • DataInsights's avatar
    DataInsights
    5 years ago

    MYDATASTORY, try this measure:

     

    Time Diff = 
SUMX ( TestData, TestData[End Time] - TestData[Start Time] )

     

     

     

     

DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
5 years ago

MYDATASTORY, try this measure:

 

Time Diff = 
SUMX ( TestData, TestData[End Time] - TestData[Start Time] )