- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Display max value individual by day
Dear friends
please suggested me how i create max break in 1 day column that saying max break value individual by day, details as table below
Date | Name | Break time | Max break time in 1 day |
01-01-20 | John | 6:00 | |
01-01-20 | Jame | 5:00 | 5:00 |
01-01-20 | John | 2:00 | |
01-01-20 | John | 8:00 | 8:00 |
01-01-20 | Jame | 1:00 | |
02-02-20 | Jame | 3:00 | |
02-02-20 | Jame | 7:00 | 7:00 |
02-02-20 | John | 4:00 | 4:00 |
02-02-20 | John | 2:00 |
Can any one please suggest me.
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous
Try below DAX in a calculated column
MaxBreak =
VAR __maxTime =
MAXX (
FILTER (
'Table',
'Table'[Date] = EARLIER ( 'Table'[Date] )
&& 'Table'[Name] = EARLIER ( 'Table'[Name] )
),
'Table'[Break time]
)
VAR __result =
IF ( 'Table'[Break time] = __maxTime, __maxTime, BLANK () )
RETURN
__result
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous , Try like
if([break time] =maxx(filter(table, [name]=earlier([name]) && [date]=earlier([date])),[break time]) ,[break time],blank())
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous
Try this as measure:
Measure =
VAR BT =
CALCULATE(
MAX('Table'[Break time ]),
ALLEXCEPT('Table', 'Table'[Name ],'Table'[Date ]))
RETURN
IF( BT = MAX('Table'[Break time ]),FORMAT(BT,"hh:mm"),"")
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous
Try this as measure:
Measure =
VAR BT =
CALCULATE(
MAX('Table'[Break time ]),
ALLEXCEPT('Table', 'Table'[Name ],'Table'[Date ]))
RETURN
IF( BT = MAX('Table'[Break time ]),FORMAT(BT,"hh:mm"),"")
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous
Try below DAX in a calculated column
MaxBreak =
VAR __maxTime =
MAXX (
FILTER (
'Table',
'Table'[Date] = EARLIER ( 'Table'[Date] )
&& 'Table'[Name] = EARLIER ( 'Table'[Name] )
),
'Table'[Break time]
)
VAR __result =
IF ( 'Table'[Break time] = __maxTime, __maxTime, BLANK () )
RETURN
__result
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@nandu_krishna nice solution, i have another question what if i need to show "Need a break" instead of show max break in Max break in 1 time column what should i do cause i just try to adjust your dax like below but its go wrong.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous
In your DAX, I could see that you are not returning the __result variable.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
09-01-2024 11:51 PM | |||
02-05-2024 11:15 AM | |||
10-03-2024 03:19 PM | |||
02-10-2023 05:55 AM | |||
09-16-2024 02:22 PM |