Forum Discussion

slounsbury's avatar
slounsbury
Helper II
8 years ago
Solved

Combine Rows and Select Earliest Date

I am wanting to combine rows that have like ticket numbers and create a new column that will only display the the ealierst date from those tickets. I am fairly new to PBI so I apologize if more info is needed or is not detailed correctly.

 

Currently the table looks like this:

 

SR_Service_RedIDEntered_ByTime_Start_UTCTime_End_UTC
123456joe11/6/17 8:30 PM11/6/17 9:30 PM
123456bob11/7/17 10:30 PM11/7/17 11:00 PM
123456tim11/8/17 6:30 PM11/8/17 7:00 PM
987654bob12/6/17 6:30 PM12/6/17 7:00 PM
987564joe12/12/17 9:30 PM12/12/17 10:00 PM
987654tim1/11/18 6:30 PM1/11/17 7:00 PM

 

I am the new column to just display the first time entry on the ticket like this:

 

SR_Service_RedIDEntered_ByTime_Start_UTCTime_End_UTCFirst_Time
123456joe11/6/17 8:30 PM11/6/17 9:30 PM11/6/17 8:30 PM
123456bob11/7/17 10:30 PM11/7/17 11:00 PM11/6/17 8:30 PM
123456tim11/8/17 6:30 PM11/8/17 7:00 PM11/6/17 8:30 PM
987654bob12/6/17 6:30 PM12/6/17 7:00 PM12/6/17 6:30 PM
987564joe12/12/17 9:30 PM12/12/17 10:00 PM12/6/17 6:30 PM
987654tim1/11/18 6:30 PM1/11/17 7:00 PM12/6/17 6:30 PM

 

Or somehow create a column that marks the first time and then I can sort it out while making the report.

 

Thanks!

 

 

 

  • slounsbury's avatar
    slounsbury
    8 years ago

    Was able to figure out how to create the column by using:

     

    column = CALCULATE(MIN(Time_Entry[Time_Start_UTC]), FILTER(Time_Entry, Time_Entry[SR_Service_RecID]=EARLIER([SR_Service_RecID])))

1 Reply

  • slounsbury's avatar
    slounsbury
    Helper II
    8 years ago

    Was able to figure out how to create the column by using:

     

    column = CALCULATE(MIN(Time_Entry[Time_Start_UTC]), FILTER(Time_Entry, Time_Entry[SR_Service_RecID]=EARLIER([SR_Service_RecID])))