Hi,
An extract of my data in powerpivot is the first 3 columns of the following:
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
For each customer where the 'count' is 1, I need to reference the prior order date where the count was also 1 (in current row context).
The prior date will be the current order date for the first record per customer (again where the count is 1).
The desired result is shown in the 'Prior Date with a Count' field.
Can this be achieved in powerpivot?
thanks
An extract of my data in powerpivot is the first 3 columns of the following:
Order Date | Customer | Count | Prior Date with a Count |
01/04/2016 | A | 0 | |
28/04/2016 | A | 1 | 28/04/2016 |
30/06/2016 | A | 0 | |
15/07/2016 | A | 1 | 28/04/2016 |
01/04/2016 | B | 1 | 01/04/2016 |
05/05/2016 | B | 1 | 01/04/2016 |
18/06/2016 | B | 1 | 05/05/2016 |
20/07/2016 | B | 0 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
For each customer where the 'count' is 1, I need to reference the prior order date where the count was also 1 (in current row context).
The prior date will be the current order date for the first record per customer (again where the count is 1).
The desired result is shown in the 'Prior Date with a Count' field.
Can this be achieved in powerpivot?
thanks