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, 2022 in Power BI by Edureka
• 13,670 points

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.

Unlock the Power of Data Visualization with Our Comprehensive Power BI Course!

answered Mar 14, 2022 by gaurav
• 23,260 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
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,910 points
+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
0 votes
1 answer
0 votes
1 answer

powerbi embeded in .net core 1.1

See if it helps: ...READ MORE

answered Nov 28, 2018 in Power BI by Upasana
• 8,620 points
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
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
0 votes
1 answer

How to load large images in PowerBi

To get around this, separate the image's ...READ MORE

answered Mar 2, 2022 in Power BI by gaurav
• 23,260 points
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, 2022 in Power BI by gaurav
• 23,260 points
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP