Lookupvalue min ?

[Phil11]

Hi, 

I'm trying to calculate a column of min and max value with many conditions and report this value in theses columns 

Ex : Agent 1 have many login for the day 16 , I would like to report in Login Colum the first login of the day

So I need to take care about Agent, day and Column1 

Have you got any ideas ? 

Thanks you so much for your help.

Phil

[Phil11]

I have already tried this but not working: 

login = CALCULATE(min('event storage copie'[H];filter(CALCULATETABLE('event storage copie');'esirius agentconfig'[Agent]='event storage copie'[Agent]&'event storage copie'[date]='event storage copie'[date])))

and this  :

Login =
CALCULATE (
FIRSTNONBLANK ( 'event storage copie'[h]; TRUE () );
FILTER (
'event storage copie';
'event storage copie'[Column1] = "LOGIN"
&& 'event storage copie'[h] = MIN('event storage copie'[h]) && 'event storage copie'[Agent]='event storage copie'[Agent] && 'event storage copie'[Date2]='event storage copie'[Date2]
)
)

[Stachu · Accepted solution]

try this, probably you will have to change the Name column to fit your data

login =
VAR CurrentAgent = 'event storage copie'[Name]
VAR CurrentDate = 'event storage copie'[Date]
RETURN
    CALCULATE (
        MIN ( 'event storage copie'[H] ),
        FILTER (
            'event storage copie',
            'event storage copie'[Column1] = "LOGIN"
                && 'event storage copie'[Name] = CurrentAgent
                && 'event storage copie'[Date] = CurrentDate
        )
    )

[Phil11]

Great idea !! Thanks a lot it's working  🙂