Forum Discussion
calculating NPV
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 )
What is NPV and how would you calculate it normally if you weren't using Power BI?
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.
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.
