Display max value individual by day

[Anonymous]

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 

[nandu_krishna · Accepted solution]

@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 🙂

[amitchandak · Accepted solution]

@Anonymous , Try like

if([break time] =maxx(filter(table, [name]=earlier([name]) && [date]=earlier([date])),[break time]) ,[break time],blank())

[Fowmy · Accepted solution]

@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 🙂

YouTube, LinkedIn

[amitchandak · Accepted solution]

@Anonymous , Try like

if([break time] =maxx(filter(table, [name]=earlier([name]) && [date]=earlier([date])),[break time]) ,[break time],blank())

[nandu_krishna · Accepted solution]

@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 🙂

[Anonymous]

@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 🙂

[Anonymous]

@nandu_krishna Thank you so much : )