How to get the first and last value based on a date and hour

[FranciscoJVV]

So i have a colums where i get the date and hour, for example on 01/21 i can have 3 values in diferrent hours, like 01/21 10:00 ; 01/21 09:20 ; 01/21  13:05, and i need to get only the 01/21 09:20 wich is the first date that day, and the same but with the last date

[KHorseman · Accepted solution]

I'm guessing you're already using a plain date column as a slicer or something like that in order to select the date. If not, may I suggest doing that? From there the first would just be MIN(TableName[DateTimeColumn]) and the last would be MAX(TableName[DateTimeColumn]).

Unless you're trying to do this as another column rather than a measure, in which case I'm not sure how you would want that to work. Would you want all three rows for 1/21 to show the 9:20 time?

[FranciscoJVV]

thanks for the help, I've been using power bi like a week ago, so I'm learning all the comands

[KHorseman]

I can sympathize. I've been using it since the day it was released to the public and I'm still learning. 😁