Excel Forum

DAX PowerPivot - How to calculate the following problem

Hai Liu

New Member

Members

Forum Posts: 1

Member Since:
February 17, 2020

Offline

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	4501+5002	4331+4802	4181+4602

Thank you very much!

Hai

Catalin Bombea

Iasi, Romania

Admin

Forum Posts: 1810

Member Since:
November 8, 2013

Offline

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: Jeanine Hagge

Guest(s) 10

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 871

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

Jessica Stewart: 205

A.Maurizio: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

Othman AL MUTAIRI

Misael Gutierrez Sr.

Attif Ihsan

Kieran Fee

Murat Hasanoglu

Brett Dryland

Saeed Aldousari

Bhuwan Devkota

Kathryn Patton

Maria Conatser

Forum Stats:

Groups: 3

Forums: 24

Topics: 6222

Posts: 27293

Member Stats:

Guest Posters: 49

Members: 31917

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen