Forum Discussion
Solved
earliest and latest dates
I have a dataset that lists every date a client was staying with us, with a unique customer visit id in another column. What would be a good way to identify the check-in and check-out dates (and id...
petehorsch , New column
Min Date = minx(filter(Table, [unique customer id] = earlier([unique customer id]) ), [Date])
Max Date = Max (filter(Table, [unique customer id] = earlier([unique customer id]) ), [Date])
measures
Min Date = Min(Table[Date])
Max Date = Min(Table[Date])
amitchandak
Super User
Super Userpetehorsch , New column
Min Date = minx(filter(Table, [unique customer id] = earlier([unique customer id]) ), [Date])
Max Date = Max (filter(Table, [unique customer id] = earlier([unique customer id]) ), [Date])
measures
Min Date = Min(Table[Date])
Max Date = Min(Table[Date])
This worked well, thank you. I had to include an extra "x" (maxx) to get the Max Date to work, but then it was perfect.