Calculate cycle time with transaction data

hi, briantc 

I'm happy to answer your questions. Sorry to hear that you are not sorting when importing data into power BI and it does not work when using calculated columns.  First of all, if the connection method we choose is the Import connection, we can sort the data in Power Query.

My sample data is as follows:

In Power BI table view:

Using Power Query to sort data:

The result after sorting:

If the above sorting method helps you, that's great. If you have any questions, please let me know and I will do my best to solve your problem.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.