Hi
My powerpivot data, simplistically, is set up like so:
<colgroup><col style="text-align: center;"><col span="2" style="text-align: center;"></colgroup><tbody>
</tbody>
My goal is to:
Find the date the customer was last invoiced
Where the net invoice value is greater than 0
Also bring back the associated value
The desired result would be as follows:
<colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>
</tbody>
Is this possible? Thanks
My powerpivot data, simplistically, is set up like so:
Date | Customer | Value |
01/01/2014 | A | 261 |
01/01/2014 | B | 127 |
01/01/2014 | C | 203 |
01/02/2014 | A | 402 |
01/02/2014 | B | 127 |
01/02/2014 | C | 203 |
01/02/2014 | D | 560 |
01/03/2014 | A | 261 |
01/03/2014 | A | -261 |
01/03/2014 | C | 203 |
01/03/2014 | D | 400 |
<colgroup><col style="text-align: center;"><col span="2" style="text-align: center;"></colgroup><tbody>
</tbody>
My goal is to:
Find the date the customer was last invoiced
Where the net invoice value is greater than 0
Also bring back the associated value
The desired result would be as follows:
Measures | ||
Customer | Date | Value |
A | 01/02/2014 | 402 |
B | 01/02/2014 | 127 |
C | 01/03/2014 | 203 |
D | 01/03/2014 | 400 |
<colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>
</tbody>
Is this possible? Thanks