kimknguyen
Member
Dear Chandoo.org's Experts,
Please help...
Attached is a list of customers and the days that they visit our shop. I need to calculate the visit number (1st, 2nd, and so on) of individual customers. I can set it up in Excel but since there are >100,000 records and counting, the calculation gets slower and slower.
I would like to do it in Power Query but need your help.
Thank you,
kim
Please help...
Attached is a list of customers and the days that they visit our shop. I need to calculate the visit number (1st, 2nd, and so on) of individual customers. I can set it up in Excel but since there are >100,000 records and counting, the calculation gets slower and slower.
I would like to do it in Power Query but need your help.
Thank you,
kim