Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
65
Views
Topic starter
Hi,
I am trying to figure out the way to achieve the goal on the 3rd table using the data from 1st and 2nd table in PowerPivot (DAX formula). Is there anyone who can help me?
Table 1
| Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| New Well Count of Field 1 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 0 |
Table 2
| Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| Typical Oil Well Production Curve(barrels of oil per month) | 500 | 480 | 460 | 450 | 433 | 418 | 403 | 388 |
The goal I want
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | |
| Field 1 | 0 | 0 | 500*1 | 480*1 | 460*1 | 450*1+500*2 | 433*1+480*2 | 418*1+460*2 |
Thank you very much!
Hai
Posted : 17/02/2020 10:29 pm
Hi Hai,
In your goal table there is no relationship to the first 2 tables, can you clarify? For example, Goal table has this: 500*1, but table 2 has 460 for month 3, not 500. Also, for month 6 you have in table 2 the value 418 and in goal you have : 450*1+500*2. A clear calculation algorithm is needed, for now it's impossible to see a pattern.
Posted : 19/02/2020 1:20 am
