Excel PowerPivot DAX equivalent to INDEX MATCH
$30-250 AUD
Dibayar semasa penghantaran
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.
ID Projek: #14990349
Tentang projek
Dianugerahkan kepada:
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 Lagi
12 pekerja bebas membida secara purata $137 untuk pekerjaan ini
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 Lagi
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 Lagi
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 Lagi