I have a table in PowerPivot that has a list of Policy Numbers and Reporting Months. I am trying to count the number of Policy Numbers that show up in the next month.
For Instance, in the table below, I want the output to say in January to say "3" (There was one policy number that duplicated twice, and one policy that duplicated once). It only counts the next months policy numbers.
<tbody>
</tbody>
Once I have this setup, I will need to do the same, but to count in the next two months instead of just one.
Any ideas?
For Instance, in the table below, I want the output to say in January to say "3" (There was one policy number that duplicated twice, and one policy that duplicated once). It only counts the next months policy numbers.
Reporting Date | Policy Number |
1/1/2015 | TEIKI23 |
1/1/2015 | FKKI45 |
2/1/2015 | TEIKI23 |
2/1/2015 | TEIKI23 |
2/1/2015 | FKKI45 |
<tbody>
</tbody>
Once I have this setup, I will need to do the same, but to count in the next two months instead of just one.
Any ideas?