Encerrado

Power Query troubleshooting

I need an advanced Power Query/Excel user to SUM the values of a Product ID between 3 different tables with its corresponding date. It is very important to know Date handling.

The tables contain a *Product ID* column and *Date* Columns as well, so we should be able to make a double match, the 1st match is of Product ID, and the 2nd is of Date.

We have 3 different tables, and we can create an independent query for each table to upload the data of each one, and then, create a 4th query where we make those transformations, where we sum the quantities of each product id with its corresponding Date Column.

--> $5 USD/hour

*Necessary abilities: Power Query, M Language, Data Transformation

Habilidades: Excel, Processamento de dados

Sobre o Cliente:
( 4 comentários ) Aguascalientes, Mexico

ID do Projeto: #33730647

30 freelancers estão ofertando em média $4/hora nesse trabalho

AAGGMM

Hello sir I am Ahmed, a GOOGLE certified data analytic with very good skills in spreadsheets [(Google sheets and Excel); including advanced formula, macros, power query and pivot tables], SQL and R-Programming languag Mais

$5 USD / hora
(45 Comentários)
4.7
(40 Comentários)
4.8
(10 Comentários)
4.1
surya2chandra

I understood the requirement that to match product id and date columns between three tables and to sum the quantity. I have good experience in power queries. Please let me know the sample data. Thanks.

$5 USD / hora
(18 Comentários)
4.2
rahulg5466

--------I CAN DO IT RIGHT AWAY-------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VB, building an excel file, excel dashboard, pivot tables, charts, v Mais

$5 USD / hora
(15 Comentários)
3.6
muhammadumar84

Hi, I have gone through your project placement & it matches my expertise. As an expert in Excel with advance level skill, I offer my services to aggregate data from different tables. With over 13 years of experience a Mais

$5 USD / hora
(16 Comentários)
3.6
Ibrahim8896

Hello There I have 5 years of experience in product listing , data entry , graphic designing. I can start work immediately and can deliver high quality result inside the deadline. If I do work on this project, you shou Mais

$2 USD / hora
(2 Comentários)
2.2
(2 Comentários)
2.3
freelancer96500

Hi,. I checked your requirement, i have Experience in below technical work. Power Bi Desktop & Services With DAX, Power Editor, Excel VBA, Power Query, Power Pivot, Advance Excel, Excel Dashboard dy Mais

$5 USD / hora
(1 Comentário)
2.3
Work12345x

Hi, I am a very talented software programmer with 13+ years of development experience (5+ years professional work experience). I am a results-oriented professional and possess experience using cutting-edge development Mais

$5 USD / hora
(1 Comentário)
1.8
Nosratabouhamzeh

Hi sir/madam, I'm very active and interested to work with you. My time is up to you. I have many experiences in this case and you could award your project to me and enjoy it. With best regards

$5 USD / hora
(3 Comentários)
1.7
academicwrriter

Hello, I will write English Literature papers on literary text, such as Dramas, Novels, Short stories, Poetry and summaries with a very fair price. I can write on various topics which is related to English literature. Mais

$2 USD / hora
(2 Comentários)
1.4
MostafaMansour1

4$ is ok i can start immediately, just contact me and let's start and i'm sure that you will get best value for money.

$4 USD / hora
(2 Comentários)
1.6
(1 Comentário)
1.1
singhpam87

dear sir, i read this job's description and understand that i am perfect for this job.I have a lot of experience in this [login to view URL] you hire me for the project if you hire me , i can completed it very carefully and satisfi Mais

$2 USD / hora
(0 Comentários)
0.0
uzzolhossen

Hi, I have checked your attachment. I am interested & am ready to start right now. Thanks, Uzzol

$2 USD / hora
(0 Comentários)
0.0
Rohit93391

I think I can do this work easily and fast as I am a fast typer and experience of doing work for hours at one siton excel. Please provide me the opportunity to do this project for you. Thank you

$4.5 USD / hora
(0 Comentários)
0.0
ubaidch666

Hi there, I can do this for you let me know more about the project so that i can start. hoping for an early replay. Regards

$3 USD / hora
(0 Comentários)
0.0
DanielGomez7

hola que tal, es un trabajo que sin problemas se puede realizar. tengo 7 años de experiencia trabajando en proyectos similares y considero que lo podemos lograr sin ninung problema en un tiempo corto me pongo a tu di Mais

$3 USD / hora
(0 Comentários)
0.0
Ronekiahglobal

Good day, My name is Ronekia Harper and i believe i am the perfect candidate for this job. I am proficient in Microsoft excel as i have performed many similar tasks in the past. I am highly detailed-oriented and will Mais

$4 USD / hora
(0 Comentários)
0.0