Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have 2 different time series of 8400 values. As per the figure below:
However the calculation of XNPV is exactly the same for both series as shown in teh figure. The code for both are shown below:
Scenario 3 NPV (Total) = XNPV('Scenario 3 (Time Series)',[TOTAL (Scenario 3)],'Scenario 3 (Time Series)'[Date],0,08)
and
Scenario 1 NPV (Total) = XNPV('Scenario 1 (Time Series)',[TOTAL (Scenario 3)],'Scenario 1 (Time Series)'[Date],0,08)
The same calculation in Excel with the same two series results in R745 081 242 for Scenario 3 and R1 021 094 189 for Scenario 1 which is correct.
Summing the two series provides different values as shown in the figure so they are definately different series. Not sure how to fix this glitch.
Any advice?
Paul
Solved! Go to Solution.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsRegards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português
@MFelix wrote:
Hi @palunel,
Looking at your measure both ones are pointing to the TOTAL[Scenario3] althought the time set are from scenario 1 and 3 shouldn't they be for different totals also
MFelix
Yes, of course that's the problem. I have been staring at it for an hour and did not see it. Time to go to bed.
Thanks MFelix.
Paul
User | Count |
---|---|
115 | |
95 | |
87 | |
76 | |
65 |
User | Count |
---|---|
138 | |
113 | |
110 | |
98 | |
93 |