Log In
Register
Home
DAX PowerPivot - How to calculate the following problem
Hai Liu
New Member
Members
Forum Posts: 1
Member Since:
February 17, 2020
February 17, 2020
Offline1
February 17, 2020 - 12:29 pm
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
Offline2
February 18, 2020 - 3:20 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.
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 —