Forum Discussion
Modify table tricks needed
Hei, I need some help with this table. For each Trip, I need to define its start and end time by: Lets take a unique Trip number and when the second column is Loading, take the Depart time as th...
amitchandak
Super User
Super UserAnonymous
Try a new table like
summarize(table, table[Trip number],"Depart",firstnonblank(Table[Depart],blank()),"Arrive",lastnonblank(Table[Arrive],blank()))
or
summarize(table, table[Trip number],"Depart",min(Table[Depart]),"Arrive",max(Table[Arrive]))