Hai Liu
New Member
Members
Forum Posts: 1
Member Since:
February 17, 2020
February 17, 2020
Offline
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
Member
Dashboards
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
Forum Posts: 1909
Member Since:
November 8, 2013
November 8, 2013
Offline
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: Stacy Culpepper, Simon Lane, Ross Denney, Sally Gutierrez
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1909
SunnyKow: 1432
Anders Sehlstedt: 899
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 279
lea cohen: 245
Jessica Stewart: 219
A.Maurizio: 213
Newest Members:
Francine Walshe
Sean Ladlow
Jorge Chicas
mahmoud salem
Irvine Choolo
Deon Bouwer
Amgad Squires
jim bo
Linda Bock
Hildebrando Rodrigues
Forum Stats:
Groups: 3
Forums: 24
Topics: 6834
Posts: 29981
Member Stats:
Guest Posters: 49
Members: 33567
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —