How to find the first value of a group and present both "first" and "subsequent" in one window?

[PoorBIGuy]

First of all, sorry for the long-ass title and thank you all in advance for reading and helping!

I have a data set like this in the BI:

What I am thinking about is that I hope to know which store the customer made the first purchase based on the date (5th Ave for A and Bloomingdales for B). Then I hope to see if where the custmer made subsequent purchases (maybe in the same store as the first purchaes or different stores), and I have this table in mind:

I wonder if it's doable to have this table in BI or maybe have the data set ready and I can populate this tab in Excel.

Many thanks for the help!

[jgeddes · Accepted solution]

You can get this type of result...

I achieved this with a combination of Power Query and DAX.

In Power Query you would sort and buffer your table by date (ascending), group your table by customer without aggregation (all rows) and then add an index column to the nested customer tables that explicitly dictates the purchase order. 
Load that into the desktop editor and you can create six measures. The first purchase store (Min store value when purchase order = 1), first purchase total (sum of spending when purchase order = 1) and then a measure for each store that sums the spending value when purchase order <> 1 && store = the store in question. From there put the measures into a matrix visual and play with the formatting to get the results you desire.
Hope this gets you pointed in the right direction.