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_RedID | Entered_By | Time_Start_UTC | Time_End_UTC |
| 123456 | joe | 11/6/17 8:30 PM | 11/6/17 9:30 PM |
| 123456 | bob | 11/7/17 10:30 PM | 11/7/17 11:00 PM |
| 123456 | tim | 11/8/17 6:30 PM | 11/8/17 7:00 PM |
| 987654 | bob | 12/6/17 6:30 PM | 12/6/17 7:00 PM |
| 987564 | joe | 12/12/17 9:30 PM | 12/12/17 10:00 PM |
| 987654 | tim | 1/11/18 6:30 PM | 1/11/17 7:00 PM |
I am the new column to just display the first time entry on the ticket like this:
| SR_Service_RedID | Entered_By | Time_Start_UTC | Time_End_UTC | First_Time |
| 123456 | joe | 11/6/17 8:30 PM | 11/6/17 9:30 PM | 11/6/17 8:30 PM |
| 123456 | bob | 11/7/17 10:30 PM | 11/7/17 11:00 PM | 11/6/17 8:30 PM |
| 123456 | tim | 11/8/17 6:30 PM | 11/8/17 7:00 PM | 11/6/17 8:30 PM |
| 987654 | bob | 12/6/17 6:30 PM | 12/6/17 7:00 PM | 12/6/17 6:30 PM |
| 987564 | joe | 12/12/17 9:30 PM | 12/12/17 10:00 PM | 12/6/17 6:30 PM |
| 987654 | tim | 1/11/18 6:30 PM | 1/11/17 7:00 PM | 12/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!
