Calculating NPV between two Tables

Question

The first table looks like this:&nbsp;ID&nbsp; &nbsp; &nbsp; Year&nbsp; &nbsp; &nbsp; &nbsp; ValueA&nbsp; &nbsp; &nbsp; &nbsp;2019&nbsp; &nbsp; &nbsp; &nbsp; $100A&nbsp; &nbsp; &nbsp; &nbsp;2020&nbsp; &nbsp; &nbsp; &nbsp; $100A&nbsp; &nbsp; &nbsp; &nbsp;2021&nbsp; &nbsp; &nbsp; &nbsp; $100&nbsp;The second Table looks like this:&nbsp;ID&nbsp; &nbsp; &nbsp;Discount RateA&nbsp; &nbsp; &nbsp; &nbsp;.08B&nbsp; &nbsp; &nbsp; &nbsp;.09C&nbsp; &nbsp; &nbsp; &nbsp;.07&nbsp;Need to build this out in Power Bi opposed to Excel. Appreciate any/all help!&nbsp;&nbsp;

v-yuta-msft · Answer

Anonymous，
&nbsp;
Could you please share the logic and expected results?
&nbsp;
Regards,
Jimmy Tao

anonymous · Answer

Hey, thanks for getting back to me!&nbsp;So here were the two tables again:&nbsp;ID&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;Year&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;ValueA&nbsp; &nbsp; &nbsp; &nbsp;2019&nbsp; &nbsp; &nbsp; &nbsp; $100A&nbsp; &nbsp; &nbsp; &nbsp;2020&nbsp; &nbsp; &nbsp; &nbsp; $100A&nbsp; &nbsp; &nbsp; &nbsp;2021&nbsp; &nbsp; &nbsp; &nbsp; $100&nbsp;The second Table looks like this:&nbsp;ID&nbsp; &nbsp; &nbsp;Discount RateA&nbsp; &nbsp; &nbsp; &nbsp;.08B&nbsp; &nbsp; &nbsp; &nbsp;.09C&nbsp; &nbsp; &nbsp; &nbsp;.07&nbsp;What I want to happen is for the discount rates to match up with the IDs (So like this):&nbsp;ID&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;Year&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Value&nbsp;&nbsp; &nbsp; Discount RateA&nbsp; &nbsp; &nbsp; &nbsp;2019&nbsp; &nbsp; &nbsp; &nbsp; $100&nbsp; &nbsp; &nbsp;.08A&nbsp; &nbsp; &nbsp; &nbsp;2020&nbsp; &nbsp; &nbsp; &nbsp; $100&nbsp; &nbsp; &nbsp;.08A&nbsp; &nbsp; &nbsp; &nbsp;2021&nbsp; &nbsp; &nbsp; &nbsp; $100&nbsp; &nbsp; &nbsp;.08B&nbsp; &nbsp; &nbsp; &nbsp;2019&nbsp; &nbsp; &nbsp; &nbsp; $200&nbsp; &nbsp; &nbsp;.09B&nbsp; &nbsp; &nbsp; &nbsp;2020&nbsp; &nbsp; &nbsp; &nbsp; $200&nbsp; &nbsp; &nbsp;.09C...Etc...&nbsp;Now the result I'm looking for is the NPV for each individual ID&nbsp;ID&nbsp; &nbsp; &nbsp;NPVA&nbsp; &nbsp; &nbsp; X (whatever this value would be)B&nbsp; &nbsp; &nbsp; X (whatever value)C&nbsp; &nbsp; &nbsp; X&nbsp;(whatever value)&nbsp;Obviously this would be pretty simple to set up and build out in excel but my goal is to build out all of the logic in Power Bi, Hope this clarifies, and again, thank you so much in advance for the help!&nbsp;Best,Benji

Forum Discussion

Calculating NPV between two Tables

2 Replies

Related content

Direct Lake Model - Calculated Column/Tables

How to search specific word in table filter Calculations

Table Visual not Matching Calculated Visual

Directlake semantic model, calculated table

PowerBI - Matrix table, hide values used only for a visual calculation