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.
Hello,
I have data that looks something like this:
Date | Job Name | End Time |
|
1/1/2022 | Job A | 4:45pm | |
1/1/2022 | Job B | 5:35pm |
|
1/1/2022 | Job C | 3:30pm |
|
1/2/2022 | Job D | 4:30pm |
|
1/2/2022 | Job E | 6:00pm |
|
1/2/2022 | Job F | 8:00pm |
|
I am looking for a dax expression that can calculate the latest end time for the given day. I would like the data to look like this:
Date | Job Name | End Time | Latest Time of the Day |
1/1/2022 | Job A | 4:45pm | 5:35pm |
1/1/2022 | Job B | 5:35pm | 5:35pm |
1/1/2022 | Job C | 3:30pm | 5:35pm |
1/2/2022 | Job D | 4:30pm | 8:00pm |
1/2/2022 | Job E | 6:00pm | 8:00pm |
1/2/2022 | Job F | 8:00pm | 8:00pm |
Does anyone know a dax expression that could do this? Thanks.
Solved! Go to Solution.
Hi @jacklamlan ,
Please refer to my pbix file to see if it helps you.
Create a measure.
Measure =
CALCULATE (
MAX ( 'Table'[End time] ),
FILTER (
ALL ( 'Table' ),
'Table'[Date] = SELECTEDVALUE ( 'Table'[Date] )
&& 'Table'[Job] = SELECTEDVALUE ( 'Table'[Job] )
)
)
Or a column.
Column =
CALCULATE (
MAX ( 'Table'[End time] ),
FILTER (
( 'Table' ),
'Table'[Date] = EARLIER ( 'Table'[Date] )
&& 'Table'[Job] = EARLIER ( 'Table'[Job] )
)
)
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @jacklamlan ,
Please refer to my pbix file to see if it helps you.
Create a measure.
Measure =
CALCULATE (
MAX ( 'Table'[End time] ),
FILTER (
ALL ( 'Table' ),
'Table'[Date] = SELECTEDVALUE ( 'Table'[Date] )
&& 'Table'[Job] = SELECTEDVALUE ( 'Table'[Job] )
)
)
Or a column.
Column =
CALCULATE (
MAX ( 'Table'[End time] ),
FILTER (
( 'Table' ),
'Table'[Date] = EARLIER ( 'Table'[Date] )
&& 'Table'[Job] = EARLIER ( 'Table'[Job] )
)
)
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |