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.
How can I calculate the XNPV of 2 months (from 01/2018 to 02/2018 for example) but for the next "block" calculate XNPV from 03/2018 to 04/2018)?
My data looks like this and I need to calculate the third column.
Date Value XNPV
01/2018 1 XNPV_1
02/2018 2 XNPV_1
03/2018 3 XNPV_2
04/2018 4 XNPV_2
05/2018 5 XNPV_3
06/2018 6 XNPV_3
Solved! Go to Solution.
Hi @dvhez,
Based on my test, you could refer to below formula:
XNPV = CONCATENATE(("XNPV_"),ROUND([Value]/2,0))
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi @dvhez,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He
Hi @dvhez,
Based on my test, you could refer to below formula:
XNPV = CONCATENATE(("XNPV_"),ROUND([Value]/2,0))
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi there,
If you would instead of XNPV_1, XNPV_2, etc. put in the actual values I am sure that I or someone else will answer you right away with a solution.
Best regards,
Kristjan
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 |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
105 | |
104 | |
89 | |
65 |