Forum Discussion
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 ...
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])))