Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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])))
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])))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |