Excel PowerPivot DAX equivalent to INDEX MATCH

已完成已发布的 6 年前货到付款

$30-250 AUD

货到付款

已完成货到付款

Hi,

I have an existing Excel document that uses a lookup table to return specific values.

The working formula I use has this general structure =INDEX(MATCH([ ]&[ ],[ ]&[ ],0)).

This formula is quite long and Excel struggles to update values quickly.

To speed up my spreadsheet I have started to convert the Excel formula over to PowerPivot using DAX formula, which I can see will vastly improve overall speed and flexibility, but I need help on the journey!

The task at hand is quite small and defined. I would like the awarded person to use Excel 2013 or 2016 with the PowerPivot add-in, to present a table in the given format from the information provided in the given reference data. Please find attached an Excel file with the content in it.

There are 4 tabs to the Excel file.

Tab 1 - Contains Reference Data of the fixed value options for each field in Tab 2 and 3.

Tab 2 - Contains the lookup table that holds the values that need to be returned to Tab 4.

Tab 3 - Contains the working data file that staff will add rows to on a day-to-day basis.

Tab 4 - Shows an example of the PowerPivot Table I would like presented.

PowerPivot must return the correct 'Yield' and 'Grow Day' values, by cross referencing columns B, C, D and E of the 'Orders' Table against the look-up Table 'Yield and Grow Days'.

Thanks,

Tim.

数据库开发数据库编程 Excel

项目ID： #14990349

关于项目

12个方案远程项目活跃的6 年前

想要赚钱吗？

在Freelancer上竞标的好处

设置你的预算和时间表

通过工作获取报酬

大致描述您的提案

免费注册并竞标工作

授予：

fanninson45

I have been developing software, reports and managing databases for clients on this website. I can develop your Excel PowerPivot excel application. I have 100% customer's satisfaction. Relevant Skills and Experien 更多

$133 AUD 在3天内

(21条评论)

5.9

有12名威客正在参与此工作的竞标，均价$137/小时

sandroshubladze

I am highly qualified, experienced to work for you on this project. I am very fast and accurate. Relevant Skills and Experience I am a DataBase Developer/Programmer and an Excel expert. Proposed Milestones $177 AUD 更多

$177AUD 在1天里

(188条评论)

7.8

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of ex 更多

$160 AUD 在3天内

(262条评论)

7.5

best4best

I have gone through the sample file. How many maximum rows are possible in tables? If there are less than 1,00,000 rows, Index/Match functions can work well, if it is slightly changed. Relevant Skills and Experience E 更多

$35AUD 在1天里

(128条评论)

6.3

usmanhassan123

A proposal has not yet been provided

$137AUD 在1天里

(38条评论)

5.8

MetaoriginLab

We are a Team of Technical Consultants and Data Engineers having healthy experience into Big Data technologies,IOT/Cloud/AWS and Python/AI+Machine Learning. The Dynamic force has qualified engineers having expertise in 更多

$154 AUD 在3天内

(0条评论)

0.0

jnmalau

Tim, Hire me and I'll complete your project. See below a sample output with fields 'Yield' and 'Grow Day' calculated cross referencing columns B, C, D and E of the 'Orders' Table Let's talk. Relevant Skills and Ex 更多

$200 AUD 在3天内