New Column showing if row is First Date

[Anonymous]

Hello everyone, 

I have some data, and I would like to create two new columns based on the grouping of the incident number and the arrival time. 

• 1st arriving unit - I would like to create a new boolean column stating if the datetime is the first depending on the incident number
• Did not arrive flag - If the arrival time for a certain incident number is empty, I would like to create a boolean flag as TRUE for did not arrive. 

Original data: 

Incident Number	Unit Arrived On Scene Time
PB190020726	9/26/2019 4:11 PM
PB190020736
PB190020736
PB190020736
PB190020740	9/26/2019 7:03 PM
PB190020748	9/26/2019 10:21 PM
PB190020751	9/26/2019 11:48 PM
PB190020751
PB190020751	9/26/2019 11:50 PM
PB190020751	9/27/2019 12:06 AM
PB190020774
PB190020774	9/27/2019 9:12 AM
PB190020774	9/27/2019 9:10 AM

Desired data: 

Incident Number	Unit Arrived On Scene Time	1st Unit?	didnotarriveflag
PB190020726	9/26/2019 4:11 PM	TRUE	FALSE
PB190020736		FALSE	TRUE
PB190020736		FALSE	TRUE
PB190020736		FALSE	TRUE
PB190020740	9/26/2019 7:03 PM	TRUE	FALSE
PB190020748	9/26/2019 10:21 PM	TRUE	FALSE
PB190020751	9/26/2019 11:48 PM	TRUE	FALSE
PB190020751		FALSE	TRUE
PB190020751	9/26/2019 11:50 PM	FALSE	FALSE
PB190020751	9/27/2019 12:06 AM	FALSE	FALSE
PB190020774		FALSE	TRUE
PB190020774	9/27/2019 9:12 AM	FALSE	FALSE
PB190020774	9/27/2019 9:10 AM	TRUE	FALSE

Would you know how I can do this? 

Thank you for your help, 

Denisse 

[Anonymous · Accepted solution]

Try this:

1st arriving unit = SWITCH(TRUE(),

Planilha1[Unit Arrived On Scene Time] = BLANK(), "FALSE",

Planilha1[Unit Arrived On Scene Time] = Calculate(Min(Planilha1[Unit Arrived On Scene Time]) , Filter(Planilha1, Planilha1[Incident Number]=Earlier([Incident Number]))), "TRUE", "FALSE")

Did not arrive flag = IF(Planilha1[Unit Arrived On Scene Time] = BLANK(), "TRUE", "FALSE")

[Anonymous]

@Anonymous it seemed to work, thank you so much!

[amitchandak]

@Anonymous , Please try the new columns in  dax , you can take the first one as Var in the second , if needed

First Date = minx(filter(Table,[Incident Number] =earlier([Incident Number]) && not(isblank([Unit Arrived On]))),[Unit Arrived On])

Time 1st Unit = if( [Unit Arrived On] = [First Date] , true(), false())

[Anonymous]

This is a job for Power Query, not for DAX.