Help with MAX date and time in column or measure

[J_L]

Hi team,

Hope you've all been well, all things considered.

I need help with finding the latest date and time from two related columns Date and Time. My desired outcome would be the third column MAX Date & Time 

Date	Time	MAX Date & Time
11-Sep-21	12:00 PM	13/09/2021 16:00
11-Sep-21	11:00 AM	13/09/2021 16:00
11-Sep-21	2:00 PM	13/09/2021 16:00
12-Sep-21	9:00 AM	13/09/2021 16:00
12-Sep-21	6:00 AM	13/09/2021 16:00
13-Sep-21	9:00 AM	13/09/2021 16:00
13-Sep-21	4:00 PM	13/09/2021 16:00
13-Sep-21	12:00 PM	13/09/2021 16:00

I've tried adding a column with the following measure Latest date and time = MAX((Query1.Date) &" "&(Query1.Time)) but it's not working. I can do this in excel no problems but not DAX/Power BI.

Thanks in advance for your help!!!

[J_L]

Thanks @Greg_Deckler !!! Much appreciated...  I was pulling my teeth out trying to work it out, also did lots of google searches too 😀

[Greg_Deckler · Accepted solution]

@J_L Maybe:

Max Date & Time Column =
  VAR __MaxDate = MAX([Date])
  VAR __MaxTime = MAXX(FILTER('Table',[Date]=__MaxDate),[Time])
RETURN
  __MaxDate & " " & __MaxTime