Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
palunel
Helper I
Helper I

XNPV gives same result for 2 different time series

I have 2 different time series of 8400 values.  As per the figure below:

 

 

 

Capture.PNG

 

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

 
 
1 ACCEPTED SOLUTION
MFelix
Super User
Super User

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

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

2 REPLIES 2
MFelix
Super User
Super User

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

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

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

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.