Find Jobs
Hire Freelancers

Power Query troubleshooting

$2-8 USD / hour

クローズ
投稿日: 2年近く前

$2-8 USD / hour

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
プロジェクト ID: 33730647

プロジェクトについて

29個の提案
リモートプロジェクト
アクティブ 2年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に29人のフリーランサーが、平均$4 USD/時間で入札しています
ユーザーアバター
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 language, also in data processing, cleansing, organization, and integrity. I achieved many excel projects and finish them with 5 stars and excellent reviews So, I can achieve this task perfectly. If you are interested in my offer, please feel free to contact me to discuss the details. Regards Ahmed
$5 USD 40日以内
5.0 (110 レビュー)
5.7
5.7
ユーザーアバター
--------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 lookup, word, excel database, and Microsoft office at large since that is my area of expertise within your minimal budget and provide quality work within the time required, I can also provide samples of my work. Let's discuss more in the chatbox. Regards Rahul
$5 USD 40日以内
5.0 (42 レビュー)
5.1
5.1
ユーザーアバター
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 40日以内
5.0 (23 レビュー)
4.4
4.4
ユーザーアバター
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 and advance level expertise in excel, I can automate processes, make Fully dynamic, Real time updating Financial Reports, Models & Dash boards through formulas, Pivot tables, pivot charts, Power query, Power BI and Macros. I can easily apply complex formulas including Lookups, summarizing and conditional functions. Compiling Data from different sources, cleaning and transforming it to a standard form in most efficient way for optimal integration with advanced excel features, analyzing and then Reporting in a presentable way is a routine. You can expect a very professional outcome. FIELD: Financial & Management Reporting, Financial Analysis, Forecasting & Budgeting TOOLS: MS Excel, Word & PPT. Looking forward to your Response Regards
$5 USD 40日以内
4.9 (16 レビュー)
3.6
3.6
ユーザーアバター
Good data, I would like to offer my proposal. I'm well experienced data analyst and I spent plenty of hours in Power Query. I had simillar tasks during my daily basis (a lot with handling date data). I have checked attached photos and I am sure that I can find solution quickly. If you did not pick up freelancer yet, please text me and I will send estimate solution and done project in Excel. Best Regards,
$5 USD 10日以内
5.0 (6 レビュー)
3.6
3.6
ユーザーアバター
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 should get satisfactory results. Please discuss in more detail about project via chat Regards: Ibrahim Khan
$2 USD 40日以内
5.0 (3 レビュー)
2.4
2.4
ユーザーアバター
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 dynamically with VBA Codes. Knowledge About Json file, SQL, MS Access with VBA etc. For More Details Check my Portfolio's Sample Work. With Best Regards, Data Analyst/Power bi Specilist
$5 USD 12日以内
5.0 (1 レビュー)
2.3
2.3
ユーザーアバター
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 40日以内
5.0 (3 レビュー)
1.8
1.8
ユーザーアバター
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. I take pride in my work. I render a quality service in any writing niche. I can provide original, plagiarism free work at all times. I will do the work within the specified time range. Follow your instructions and if you have any concerns about the work, be willing to go over it again until you are satisfied. Areas that I will cover in writing: English Literature History of English literature American literature Poetry Short Stories Shakespeare Novel summaries Renowned Writers and Novelists of English Etymology Critical Analysis Literary Analysis I am good at Data Processing and Excel
$2 USD 1日以内
5.0 (2 レビュー)
1.4
1.4
ユーザーアバター
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 25日以内
5.0 (2 レビュー)
1.6
1.6
ユーザーアバター
Hi, Greetings! I would love to work on the above work. I've meticulously studied the primary briefing and found myself suitable for the work. I've vast skills, and experiences on Business planning and analysis, PowerPoint presentation, data processing, statistics, research and architect of excel spreadsheet and designing customized database. I am confident that I could give you full support on-time and satisfied with my work quality and services. Click to my profile link, https://www.freelancer.com/u/sadaruddinshibly and write text to my chat box for the details discussion please. I'm ready to start your project anytime. Looking forward to hearing from you. Best regards Shah Md. Sadaruddin Shibly
$5 USD 40日以内
4.8 (4 レビュー)
1.4
1.4
ユーザーアバター
Hi, I have checked your attachment. I am interested & am ready to start right now. Thanks, Uzzol
$2 USD 50日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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.50 USD 35日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 40日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 disposición saludos!
$3 USD 40日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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 provide accurate calculations for your project. I have excellent interpersonal skills and work well as a valuable team member. I am certain I will make an excellent employee. Thank you in advance for your consideration, i look forward to hearing from you soon. Sincerely, Miss Ronekia Harper
$4 USD 40日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hi.. I will do your work by importing tables in excel using power query function. Then compare between different columns like "product ID" and "date" after comperison add a new colum for the sum of each product id with coreponding date. Please text me to start my task. Regards
$5 USD 40日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hi i have total 6 year of experience and i can easily help you with the power query do let me know if you also want to build a dashboard/power bi report which can automatically refresh
$5 USD 20日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hi My name is Pablo. I have experience working with Power Query and I can help you. If I understood correctly, youy have three data tables like the ProdID image and need to merge them all and sum values by ProductID and date. What I can´t figure out is what the SumABC image is about, I assume that is a kind of example, but I'm not sure how it was build. Anyway, if we could have a little talk on the chat, I'd be glad to lend you a hand with this Thanks for reading Pablo
$5 USD 5日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hello I have lots of experience in Excel, data entry, vba, macro. I will guarantee the quality of the job. I hope you give me a chance to work with you. Please kindly message me. Thank you.
$5 USD 40日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

MEXICOのフラグ
Aguascalientes, Mexico
5.0
5
お支払い方法確認済み
メンバー登録日:11月 8, 2021

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。