Generating NPV estimates in Powerquery for PowerBI

Question

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

Answer 1

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!