Forum Discussion
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
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 __resultDid I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂Anonymous , Try like
if([break time] =maxx(filter(table, [name]=earlier([name]) && [date]=earlier([date])),[break time]) ,[break time],blank())
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 🙂
6 Replies
- nandu_krishna
Microsoft Employee
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 __resultDid I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂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.
Event =VAR __maxTime =MAXX (FILTER ('Detailed Trip Report (Break)','Detailed Trip Report (Break)'[Date] = EARLIER ( 'Detailed Trip Report (Break)'[Date] )&& 'Detailed Trip Report (Break)'[AssetName] = EARLIER ( 'Detailed Trip Report (Break)'[AssetName] )),'Detailed Trip Report (Break)'[ref.Event])VAR __result =IF ( 'Detailed Trip Report (Break)'[ref.Event] = __maxTime,"Need more break", BLANK () )RETURN- nandu_krishna
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 🙂
- amitchandak
Super User
Anonymous , Try like
if([break time] =maxx(filter(table, [name]=earlier([name]) && [date]=earlier([date])),[break time]) ,[break time],blank())
- Fowmy
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 🙂