Forum Discussion
GeekAlfPro
Helper V
Helper VGet max hour from max date
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 th...
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]+timethen use measure = maxx(allselected(Table), Table[Datetime])
amitchandak
Super User
Super UserGeekAlfPro , 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])
GeekAlfProHelper V
Helper V