Forum Discussion

104731's avatar
104731
Frequent Visitor
8 years ago
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"

 

 

ProjectIDPropertyNameRow_labelFYValuediscount Rate
5422020 K Street FINALCash Flow1/1/2018-404995.40220.0575
5422020 K Street FINALCash Flow1/1/20197634819.340.0575
5422020 K Street FINALCash Flow1/1/202016472491.630.0575
5422020 K Street FINALCash Flow1/1/202116481923.110.0575
5422020 K Street FINALCash Flow1/1/202212334513.230.0575
5422020 K Street FINALCash Flow1/1/202317325660.20.0575
5422020 K Street FINALCash Flow1/1/202418154972.390.0575
5422020 K Street FINALCash Flow1/1/202515537829.810.0575
5422020 K Street FINALCash Flow1/1/20269083829.1530.0575
5422020 K Street FINALCash Flow1/1/20273762907360.0575

 

Any helop would be appreciated.

 

Thanks in advance.

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

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

    • 104731's avatar
      104731
      Frequent Visitor
      8 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        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.

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    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