PowerQuery - Dynamic Filtering -- 2
€30-250 EUR
Pago na entrega
This is not project for junior. If you are junior please do not apply for this project.
I am seeking a skilled professional with expertise in PowerBI, PowerQuery, and SQL to complete a project for me. Please carefully review the project documentation before applying. Candidates who do not demonstrate a thorough understanding of the project requirements or fail to provide adequate project steps/functions in their application will not be considered.
If you do not possess the necessary experience with PowerBI, Excel, PowerQuery, and SQL, please refrain from applying for this position. The end result of the project will be a functional PowerQuery pbix file, and payment will be made upon successful implementation and testing on our side.
I am looking for a PowerQuery expert who can assist me with dynamic filtering of an Excel Workbook. The ideal candidate should have experience with data transformation and applying of dynamic filtering based on various ranges for various fields. The data source for the PowerQuery will be an Excel Workbook. The specific criteria for the dynamic filtering include Date Ranges. The expert should be able to create effective dynamic filter the data based on the criteria that can change in time. Please only apply if you have relevant experience and skills in PowerQuery and data transformation and SQL.
Our budget is 60Eur.
There is a dynamic filter/criteria in Code_management sheet where we can ADD or REMOVE row which will affect final count of rows in TLR. Using Code_management we filter out the ROWS from TLR sheet.
In [login to view URL] are 2 sheets:
Sheet Code_management is group of filters that needs to be applied:
-if Code To is not NULL then means RANGE Code -> Code To
-if Code To = NULL then it is not RANGE but 1 value only = Code
ONLY EXAMPLE CRITERIA - If we change the criteria in these fields/columns the result will change.
-FC example: Include ALL ROWS where FC except: 1010E, 4143, 3057
-GL example: Include ONLY ROWS where GL in RANGE 30000->99999 AND ROWS where GL = 23400
-PC example: Include ONLY ROWS where PC = 0
-AF example: Include ONLY ROWS where AF in RANGE (one of 26 RANGES)
Sheet TLR:
col A -> D: Values you need to filter by
col J -> M: Evaluation that needs to be evaluated of every column filter 1=INCLUDE, 0=EXCLUDE
col N: FINAL EVALUATION that needs to be evaluated = means if any of col J->M = 0 then 0, else 1
Blackmailing proposals and communication will be rejected with any further notice and future cowork. Please be professional!
ID do Projeto: #36552164
Sobre o projeto
Concedido a:
I have read the offer, and I am perfectly qualified for the project. I am a Mathematics expert in Excel and data analysis with specialized critical thinking skills in developing relational databases based on SQL, R, Py Mais
21 freelancers estão ofertando em média €179 nesse trabalho
Hello, I am a Data Analyst and Power BI expert and I can perfectly assist you in dynamic filtering with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all t Mais
Hi, I have more then 15 year’ experienced in Development. As i am expert, I can build it according to your requirements. Because I have a lot of the experiences about these fields, I can build your project as soon Mais
Greetings I am experienced MS Machine Learning expert & Data Scientist, Software Engr, MS Excel Expert and Certified Graphics Designer. I have 08 yrs of experience in the field of Machine Learning and Designing. I hav Mais
Hello, I am a Data Analyst and Power BI expert and I can perfectly assist you in dynamic filtering with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all t Mais
Yo! Speaking of this project PowerQuery - Dynamic Filtering -- 2, I am delighted to work on it. Being the most reputed freelance writer on this website, with over a decade of experience and maximum number of reviews on Mais
Hi, ⭐⭐⭐It's me you're looking for.⭐⭐⭐ Hi, there. ⭐⭐⭐ I would like to ask few questions before start your project ⭐⭐⭐ ⭐⭐⭐ I will give you exact quote after detailed discussion ⭐⭐⭐ I am a specialist with 7 years prov Mais
I have Proficiency in Advance excel, power BI, SQL Strong analytical skills Knowledge of statistical techniques and data visualization tools Ability to work with large datasets and databases Good communication skills t Mais
Hey there! Are you ready to transform your Excel Workbook and take your dynamic filtering skills to the next level? Look no further because I'm the senior Power BI developer you've been searching for! With over 7 yea Mais
Hi I am at Powar be certified professional and I have extensive knowledge and that and a sequel also have worked and I am working also so I will be able to do that but first of all we can connect a let's get a get a re Mais