Forum Discussion
Solved
calculating NPV
Hi I need some help in calculating the NPV in power BI. Below is the sample data I have . when I calculate from excel the values is " $298,108,279.14" ProjectID PropertyName Row_...
Hi 104731
Try this Measure
XNPV is slightly different than NPV.
http://www.differencebetween.net/business/finance-business-2/difference-between-npv-and-xnpv/
You can compute XNPV in Excel too.
Net present Value = XNPV ( Table1, Table1[Value], Table1[FY], .0575 )
Hi 104731,
Have you tried the solution provided above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?
If you still have any question on this issue, feel free to post here. :smileyhappy:
Regards