Home

DAX Powerpivot - How to solve this problem in PowerPivot

%3CLINGO-SUB%20id%3D%22lingo-sub-1176758%22%20slang%3D%22en-US%22%3EDAX%20Powerpivot%20-%20How%20to%20solve%20this%20problem%20in%20PowerPivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1176758%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20achieve%20the%20goal%20on%20the%203rd%20table%20using%20the%201st%20and%202nd%20table%20in%20PowerPivot.%20Hope%20I%20could%20get%20help%20from%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETable%201%3C%2FP%3E%3CTABLE%20width%3D%22979%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22242%22%3EMonth%3C%2FTD%3E%3CTD%20width%3D%2272%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2272%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2272%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2272%22%3E4%3C%2FTD%3E%3CTD%20width%3D%2272%22%3E5%3C%2FTD%3E%3CTD%20width%3D%22177%22%3E6%3C%2FTD%3E%3CTD%20width%3D%22100%22%3E7%3C%2FTD%3E%3CTD%20width%3D%22100%22%3E8%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENew%20Well%20Count%20of%20Field%201%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETable%202%3C%2FP%3E%3CTABLE%20width%3D%22979%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22242%22%3EMonth%3C%2FTD%3E%3CTD%20width%3D%2272%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2272%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2272%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2272%22%3E4%3C%2FTD%3E%3CTD%20width%3D%2272%22%3E5%3C%2FTD%3E%3CTD%20width%3D%22177%22%3E6%3C%2FTD%3E%3CTD%20width%3D%22100%22%3E7%3C%2FTD%3E%3CTD%20width%3D%22100%22%3E8%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22242%22%3ETypical%20Oil%20Well%20Production%20Curve(barrels%20of%20oil%20per%20month)%3C%2FTD%3E%3CTD%3E500%3C%2FTD%3E%3CTD%3E480%3C%2FTD%3E%3CTD%3E460%3C%2FTD%3E%3CTD%3E450%3C%2FTD%3E%3CTD%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20433%3C%2FTD%3E%3CTD%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20418%3C%2FTD%3E%3CTD%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20403%3C%2FTD%3E%3CTD%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20388%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20goal%20I%20want%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22979%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22242%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2272%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2272%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2272%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2272%22%3E4%3C%2FTD%3E%3CTD%20width%3D%2272%22%3E5%3C%2FTD%3E%3CTD%20width%3D%22177%22%3E6%3C%2FTD%3E%3CTD%20width%3D%22100%22%3E7%3C%2FTD%3E%3CTD%20width%3D%22100%22%3E8%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EField%201%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E500*1%3C%2FTD%3E%3CTD%3E480*1%3C%2FTD%3E%3CTD%3E460*1%3C%2FTD%3E%3CTD%3E450*1%2B500*2%3C%2FTD%3E%3CTD%3E433*1%2B480*2%3C%2FTD%3E%3CTD%3E418*1%2B460*2%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much!%3C%2FP%3E%3CP%3Ekayyeah11%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1176758%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178420%22%20slang%3D%22en-US%22%3ERe%3A%20DAX%20Powerpivot%20-%20How%20to%20solve%20this%20problem%20in%20PowerPivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178420%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F560080%22%20target%3D%22_blank%22%3E%40kayyeah11%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ecan%20you%20explain%20the%20logic%20that%20leads%20to%20the%20results%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi,

I am trying to achieve the goal on the 3rd table using the 1st and 2nd table in PowerPivot. Hope I could get help from you.

 

Table 1

Month12345678
New Well Count of Field 100100200

 

Table 2

Month12345678
Typical Oil Well Production Curve(barrels of oil per month)500480460450         433                                    418                403                388

 

The goal I want:

 

 12345678
Field 100500*1480*1460*1450*1+500*2433*1+480*2418*1+460*2

 

Thank you very much!

kayyeah11

1 Reply
Highlighted

Hello @kayyeah11 

 

can you explain the logic that leads to the results?