Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to compute XNP for two projects, each with its own discount rate.
I have two tables:
- tblCashFlows with clomns: date | project | values
- bplRate with two column: project | rate
Formula should be
VPL = XNPV(tblCashFlows,tblCashFlows[Values],tblCashFlows[Date],XXXXX)
XXXXX should bring the discount value from tblRate.
What to write in XXXXX?
tblCashFlows
Date | Project | Value |
31-01-17 | Project1 | 100 |
02-03-17 | Project1 | 100 |
01-04-17 | Project1 | 100 |
01-05-17 | Project1 | 100 |
31-05-17 | Project1 | 100 |
30-06-17 | Project1 | 100 |
30-07-17 | Project1 | 100 |
29-08-17 | Project1 | 100 |
28-09-17 | Project1 | 100 |
28-10-17 | Project2 | 100 |
27-11-17 | Project2 | 100 |
27-12-17 | Project2 | 100 |
26-01-18 | Project2 | 100 |
25-02-18 | Project2 | 100 |
27-03-18 | Project2 | 100 |
26-04-18 | Project2 | 100 |
26-05-18 | Project2 | 100 |
25-06-18 | Project2 | 100 |
Solved! Go to Solution.
Hi @difrenkel
Try one of these to get the rate
Calculate(values(tblRate[Rate]),Filter(tblRate,tblRate[Project]=SELECTEDVALUE(tblCashFlows[Project])))
OR
LOOKUPVALUE(tblRate[Rate],tblRate[Project],SELECTEDVALUE(tblCashFlows[Project]))
Hi @difrenkel
Try one of these to get the rate
Calculate(values(tblRate[Rate]),Filter(tblRate,tblRate[Project]=SELECTEDVALUE(tblCashFlows[Project])))
OR
LOOKUPVALUE(tblRate[Rate],tblRate[Project],SELECTEDVALUE(tblCashFlows[Project]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |