Forum Discussion
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 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 !
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])
2 Replies
- amitchandak
Super User
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])
GeekAlfPro