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
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 )
How does one calculate in case of multiple projects and have different discount rates.