Generating NPV estimates in Powerquery for PowerBI

0 votes

So I am looking to generate NPVs for a number of different cases. Assume the discount rate is 10%.

Below is some sample data and I was hoping to get NPVs for all cases both for costs and for revenues.

So in this case, what would be ideal is to get:

-Neptune & Mars NPV Revenues

-Neptune & Mars NPV Costs

Ideally, in different tables ie. NPV cost table with all projects and the NPVs of each their costs and the same for the revenue NPV table. Hope you can help.

Case Profile Year Value
Neptune Cost 2021 7
Neptune Cost 2022 7
Neptune Cost 2023 5
Neptune Cost 2024 6
Neptune Revenue 2021 7
Neptune Revenue 2022 7
Neptune Revenue 2023 5
Neptune Revenue 2024 6
Mars Cost 2021 6
Mars Cost 2022 6
Mars Cost 2023 6
Mars Cost 2024 8
Mars Revenue 2021 7
Mars Revenue 2022 7
Mars Revenue 2023 5
Mars Revenue 2024 6

Mar 10 in Power BI by Edureka
• 9,700 points
34 views

1 answer to this question.

0 votes
In Excel, Data Analysis Expressions (DAX) is a mathematical expression language that is utilised in Analysis Services, Power BI, and Power Pivot. Functions, operators, and values in DAX formulas are used to execute complex computations and queries on data in connected tables and columns in tabular data models.

This essay only serves as a primer on the most significant DAX topics. It explains DAX in terms of all the products that use it. Some features may not be applicable to particular goods or scenarios. Consult the documentation for your product to learn more about its DAX implementation.

NPS Surveys Can Provide Insight
It is critical to thoroughly analyse the information you receive from your NPS survey in order to identify and address any consumer pain points.

The responses to the closed-ended question will be used to calculate your Net Promoter Score. Then you'll have to go through the information from your open-ended questions to find relevant actionable insights. Let's look at how to go about doing that.
answered Mar 14 by Edureka
• 8,820 points

Related Questions In Power BI

+1 vote
1 answer

Have column with multiple values in powerBI, for use with a slicer in power bi

It can be achieved depending on the result you ...READ MORE

answered Oct 22, 2018 in Power BI by Hannah
• 18,570 points
5,919 views
0 votes
1 answer

R scripts for Importing Data in powerBI?

There may be times when you don’t ...READ MORE

answered Nov 11, 2020 in Power BI by Gitika
• 65,850 points
466 views
+1 vote
1 answer

Show the latest value in PowerBi from ASA

Best you can do right now is ...READ MORE

answered Oct 25, 2018 in Power BI by Surendra
998 views
0 votes
1 answer
0 votes
1 answer

powerbi embeded in .net core 1.1

See if it helps: https://www.nuget.org/packages/PowerBI.NetStandar ...READ MORE

answered Nov 28, 2018 in Power BI by Upasana
• 8,620 points
580 views
0 votes
1 answer

How can I concatenate grouped values in PowerQuery ?

If your table is Source, and if ...READ MORE

answered Feb 27, 2019 in Power BI by Shubham
• 13,490 points
1,999 views
0 votes
1 answer

Calculate Total number of Male & Female in the PowerBI report

To achieve what you are looking for, ...READ MORE

answered Feb 28, 2019 in Power BI by Upasana
• 8,620 points
4,623 views
0 votes
1 answer

PowerBI Data Model and Slicers for Many-to-Many-to-Many too Many Over Time

A relationship with a many-many cardinality in Power BI ...READ MORE

answered Mar 2 in Power BI by Edureka
• 8,820 points
84 views
0 votes
1 answer

Spell check in PowerBI

Use this API service and create a ...READ MORE

answered Mar 2 in Power BI by Edureka
• 8,820 points
34 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP