
Hai Liu
New Member
Members

Forum Posts: 1
Member Since:
February 17, 2020
February 17, 2020

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

Catalin Bombea
Iasi, Romania
Admin

Forum Posts: 1844
Member Since:
November 8, 2013
November 8, 2013

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.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Marcel Bila, Riny van Eekelen, Sheryl Gill, Rob Starren, Sheilah Taylor
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
Sheilah Taylor
Clare Webber
David Jenssen
Dominic Brosnahan
Young You
Jennifer Owens
Mohamed Touahria
Sheila McCall
Nicholas Montano
John Babcock
Forum Stats:
Groups: 3
Forums: 24
Topics: 6524
Posts: 28549
Member Stats:
Guest Posters: 49
Members: 32803
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
