Get max hour from max date

[GeekAlfPro]

Hello,

I have a report wherein I want to post the last purchase on a website.

So I have inserted a card and a filter on the most recent one.

It works for the date.

but now I want to display the maximum time of day I picked in the maximum date card

i specify that my hours and dates are in separated columns

how can i filter the adjacent hour of the max date ?

I hope I am clear enough 🙂

thanks !

[amitchandak · Accepted solution]

@GeekAlfPro , Try a new measure

new measure =
var _date =maxx(allselected(Table), Table[Date])
return
calculate(max(Table[Time]), filter(Table, Table[Date] =_date))

Or create a new column
datetime = [Date]+time

then use measure = maxx(allselected(Table), Table[Datetime])

[GeekAlfPro]

Hi @amitchandak,

it's perfect !

thanks a lot.

have a good day