Add first occurence of ID to new column

[Anonymous]

I have an issue with my current project. Unfortunately I'm not able to change my indata, so I have to do this in Power Bi. (Normally I would solve this in SQL but for this task I can't.)

My indata:

I'm using this DAX
responsible = CALCULATE ( FIRSTNONBLANK('Tabel'[date],1), ALLEXCEPT('Tabel', Tabel[id] ))

Output:

I would like the name of the first person added instead of the first date, how do I do that?

[themistoklis]

@Anonymous 

try the following formula:

First responsible =
VAR _min_date =
    CALCULATE (
        MIN ( Sheet1[Time assigned] ),
        FILTER ( Sheet1, Sheet1[ID] = EARLIER ( [ID] ) )
    )
RETURN
    MINX (
        FILTER ( Sheet1, [ID] = EARLIER ( [ID] ) && [Time assigned] = _min_date ),
        [Assigned to]
    )

[amitchandak · Accepted solution]

@Anonymous , Create a new column like

new column =
var _min = minx(filter(Table,[ID] = earlier([ID])),[Time assigned])
return
maxx(filter(Table,[ID] = earlier([ID]) && [Time assigned] =_min),[Assigned to])