Forum Discussion
New Computed Column
Anonymous - You could do the following steps:
1. Order by Customer.
2. Add an index column starting from 0, and another starting from 1.
3. Merge the table with itself, joining the one index column to the other. This way, you can retrieve the previous customer.
4. Add a Custom Column that returns 0 if the current and previous customers are the same, otherwise 1.
Using an Excel formula (if the source is a spreadsheet) is easier:
1. Order by Customer.
2. Add a new column, with the following formula (Assumes that CustomerID is in Column A):
=IF(A2=A1,0,1)
Hope this helps,
Nathan
Anonymous - You could do the following steps:
1. Order by Customer.
2. Add an index column starting from 0, and another starting from 1.
3. Merge the table with itself, joining the one index column to the other. This way, you can retrieve the previous customer.
4. Add a Custom Column that returns 0 if the current and previous customers are the same, otherwise 1.
Using an Excel formula (if the source is a spreadsheet) is easier:
1. Order by Customer.
2. Add a new column, with the following formula (Assumes that CustomerID is in Column A):
=IF(A2=A1,0,1)
Hope this helps,
Nathan
Thanks Anonymous ,
I think it will help and i'm almost there.
At step 2 (i'm using PowerQuery) - you meant a column with ascending series (starting from 0) or all the column be with "0"?
EDIT:
Got you about the index coulmn, but which coulmn I need retrive after I merged?
Thanks!
Anonymous - Please refer to the following screenshot:
EDIT: The column you need is CustID, so you can compare the current row with the previous row.
Thanks Anonymous , I edited my previous reply above.