Forum Discussion
Solved
Finding first value with same ID in multiple rows based on date/time
Dear Power BI community I need help to write a DAX formular that can identify the first value in multiple rows with the same ID based on date/time. I have a table as shown below and need to calcu...
Hi spocx,
First Assign team = VAR firstassigndate = CALCULATE ( MIN ( 'table 1'[Assign date/time] ), ALLEXCEPT ( 'table 1', 'table 1'[Ticket ID] ) ) RETURN CALCULATE ( SELECTEDVALUE ( 'table 1'[Team assigned] ), FILTER ( ALLEXCEPT ( 'table 1', 'table 1'[Ticket ID] ), 'table 1'[Assign date/time] = firstassigndate ) )Best regards,
Yuliana Gu
Hi spocx,
First Assign team =
VAR firstassigndate =
CALCULATE (
MIN ( 'table 1'[Assign date/time] ),
ALLEXCEPT ( 'table 1', 'table 1'[Ticket ID] )
)
RETURN
CALCULATE (
SELECTEDVALUE ( 'table 1'[Team assigned] ),
FILTER (
ALLEXCEPT ( 'table 1', 'table 1'[Ticket ID] ),
'table 1'[Assign date/time] = firstassigndate
)
)
Best regards,
Yuliana Gu
Hi Yuliana
Your solution works perfectly. Thank you so much.
Best regards,
Jonas
HI
I have a very similar scenario, where for a project number I have multiple rows for various periods. The status changes in some periods. However, I want to see the first status for a particular project number. Using the formula above shows always just Unapproved status for some reason. E.G. for C20220510-T I should see as the first status 'Approved', for C20220514 I should see Unapproved, for C20220529-T I should see Approved. Can you help please?
