The quickest way to do this would be using the Index function (a table calc rather than your preferred LOD calc).
1. Add a new calculation to the rows shelf that is simply INDEX()
2. Convert to discrete
3. Edit Table Calculation
4. Compute Using: 'Advanced'
5. Add Customer Name, then Order date to the 'Addressing Section'
6. Apply changes
This should get you to your answer relatively quickly.