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
30 freelancers estão ofertando em média $4/hora nesse trabalho
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.
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
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