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,
Thanks for the reply
NPV in excel is Net present value calculation as shown in the image below.
But That is not working for me when I try to calculate in Power BI
Looking at Excel there are 2 NPV calculations and dax only seems to have the XNPV version. When i use XNPV in Excel and PowerBI i get the same result. You could probably write a Dax measure to do that, but i don't understand the Math formula well enough to get it right. I gave it a quick try but the Pure Math side of what the Wiki was talking about was beyond me.