Forum Discussion
XNPV through time
1. One is that at the end it just goes back to the npv of the whole thing instead of 0 or ending
I haven't reproduced your issue. It just typed 6 rows as your sample. The measure goes to the end properly in line chart.
2. it is just seems to be calculating at the points where there is data, and not every month.
This issue should be solved by add a full calendar table and build relationship to your CF table on Date column.
Regards,
1. One is that at the end it just goes back to the npv of the whole thing instead of 0 or ending
I haven't reproduced your issue. It just typed 6 rows as your sample. The measure goes to the end properly in line chart.
2. it is just seems to be calculating at the points where there is data, and not every month.
This issue should be solved by add a full calendar table and build relationship to your CF table on Date column.
Regards,