calculating NPV

[104731]

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_label	FY	Value	discount Rate
542	2020 K Street FINAL	Cash Flow	1/1/2018	-404995.4022	0.0575
542	2020 K Street FINAL	Cash Flow	1/1/2019	7634819.34	0.0575
542	2020 K Street FINAL	Cash Flow	1/1/2020	16472491.63	0.0575
542	2020 K Street FINAL	Cash Flow	1/1/2021	16481923.11	0.0575
542	2020 K Street FINAL	Cash Flow	1/1/2022	12334513.23	0.0575
542	2020 K Street FINAL	Cash Flow	1/1/2023	17325660.2	0.0575
542	2020 K Street FINAL	Cash Flow	1/1/2024	18154972.39	0.0575
542	2020 K Street FINAL	Cash Flow	1/1/2025	15537829.81	0.0575
542	2020 K Street FINAL	Cash Flow	1/1/2026	9083829.153	0.0575
542	2020 K Street FINAL	Cash Flow	1/1/2027	376290736	0.0575

Any helop would be appreciated.

Thanks in advance.

[v-ljerr-msft]

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. 

Regards

[Anonymous]

What is NPV and how would you calculate it normally if you weren't using Power BI?

[104731]

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

[Zubair_Muhammad · Accepted solution]

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 )

[GLMSDev]

How does one calculate in case of multiple projects and have different discount rates. 

[Anonymous]

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.