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
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
PowerPoint
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
PowerPoint
Forum Posts: 1939
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: Riny van Eekelen
Guest(s) 7
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 918
Purfleet: 415
Frans Visser: 349
Hans Hallebeek: 335
David_Ng: 306
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Ariel Olijar
Craig Webb
Katie Nunes
Paul Etheridge
Crystal Harris
Amaan Abdi
Sarah Yelland
Ahsan AYUB
Daniel Neilson
Joy Nicholes
Forum Stats:
Groups: 3
Forums: 25
Topics: 7060
Posts: 30941
Member Stats:
Guest Posters: 49
Members: 34434
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —