Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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?
Proud to be a Super User!
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?
Proud to be a Super User!
thanks for the help, I've been using power bi like a week ago, so I'm learning all the comands
I can sympathize. I've been using it since the day it was released to the public and I'm still learning. 😁
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
102 | |
78 | |
77 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |