Product Purchases in Order by Customer ID and Purchase Date

[andruf]

I have an Appended_Transaction Table that includes the following information below and I am trying to figure out how to combine customer purchases by their ID and see their transactions in order from earliest to latest.

The goal is to see what they purchase as new customers and what they purchase through their lifetimes with us. Then determine how they all relate like if they purchase a Mem Day Pass - Adult/Senior they are then likely to purchase x as their second purchase.

[v-chuncz-msft · Accepted solution]

@andruf,

You may take a look at thread below.

http://community.powerbi.com/t5/Desktop/Summarize-and-Rank-by-multiple-columns-and-rows/m-p/330335#M...

[andruf]

Thanks for the link to reference, that works for me.