Missing Data (Time)

Hi DannyAlfa ,

Thanks Thejeswar  for the quick reply. I have some other thoughts to add:

(1) There is a hotel name column in your expected results that does not exist in your data, where I have added the hotel name column to the test data.

(2) Create a time column.

Time = TIMEVALUE([Date])

(3)Create measures.

Min time = CALCULATE(MIN('Table'[Time]),FILTER(ALL('Table'),'Table'[Hotel Name]=MAX('Table'[Hotel Name]))) 

Max time = CALCULATE(MAX('Table'[Time]),FILTER(ALL('Table'),'Table'[Hotel Name]=MAX('Table'[Hotel Name])))  

If I have misunderstood you, please clarify in a follow-up reply. 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.