Find Jobs
Hire Freelancers

Creating calculated column in DataMart (Converting DAX code into Power Bi Power Query)

$30-250 USD

Closed
Posted 4 months ago

$30-250 USD

Paid on delivery
The following is a list of code written in DAX and needs to be converted into Power Query. The problem: we are trying to use DataMart and build report in powerBi service. To create calculated column, we can only use PowerQury or SQL in the DataMart transformation section. The following code was written in PowerBI desktop using DAX. I need someone who knows very well PowerQuery (M), who can quickly convert the following code from DAX to PowerQuey and be able to copy and paste in PowerBI Service DataMart transformation section my using custom column in Query section of the DataMart. To get paid, the code must work without any problem. Anything between ‘ ’ is the table name, and anything between is the field name. If you are an expert in PowerQuery and you have created a calculated field in DataMart, then contact me. If you haven’t please don’t
Project ID: 37640195

About the project

40 proposals
Remote project
Active 3 mos ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
40 freelancers are bidding on average $141 USD for this job
User Avatar
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$180 USD in 3 days
4.9 (611 reviews)
8.6
8.6
User Avatar
Hello, Power BI and Excel expert here. I can perfectly help you in developing a top quality Power BI report. I am an experienced Data Visualization and Data Analytics expert. I hold years of experience in using Power BI, Tableau, SQL and Excel to perform Data Visualization and Data Analytics. To make your hiring decision easier, I can share the limited version quickly before you hire and then you can decide if this fulfills your needs or not. Lets discuss your project in detail and how I am highly suitable for this.
$30 USD in 1 day
4.8 (242 reviews)
7.3
7.3
User Avatar
As an accomplished Excel expert with a proven track record in Data Analysis and Visualization, I can offer the specialized skills you require to convert DAX code into Power Query for your DataMart project. With 7 years of hands-on experience utilizing advanced level tools in Excel, I have gained a profound understanding of VBA, Macros, complex calculations, and Data Analytics; skills that seamlessly extend into Power Query. My skills align perfectly with your needs and I can assure you a powerful and smooth integration of the converted code into your DataMart. Moreover, I possess a high level of proficiency in other areas that are directly relevant to your project such as Access database management and SQL querying, which will empower me to understand both the DAX and Power Query side of your reporting requirements. This comprehensive understanding will enable me to efficiently convert the given code without any glitch. I am eager to solve complex problems and deliver impeccable work within specified deadlines. Hiring me means gaining more than just an Excel expert - it means gaining an invaluable partner who is committed to leveraging their expertise in PowerBi, Tableau, PowerPoint, and Outlook, for the success of your reporting in DataMart. Let's discuss how we can elevate your project!
$250 USD in 1 day
5.0 (44 reviews)
5.7
5.7
User Avatar
Hey, I hope you're doing well. I review your requirements and I can do this work. I have worked with Microsoft technologies for 9+ years and helped clients get the most out of SharePoint, PowerApps, Power Automate, PowerBI, Nintex, Microsoft Teams .NET, and Office365 platforms. I will demonstrate my work once we connect. Regards, Hina
$210 USD in 2 days
4.6 (13 reviews)
6.0
6.0
User Avatar
Hi There, I am reaching out to express my interest in your project (Creating calculated column in DataMart (Converting DAX code into Power Bi Power Query)) and would like to offer a 25% discount on all services. You need DataMart and build report in powerBi service. To create calculated column, we can only use PowerQury or SQL in the DataMart transformation section.. I have extensive experience for over 5 years as a Web Scraper, Data Entry and Organization, Data Cleaning, and Validation Techniques. I believe I am the perfect fit for this project because of my skills in data entry and organization as well as data cleaning and validation techniques. Additionally, I have the attention to detail and accuracy needed to process the large volume of data involved in this project efficiently and meet deadlines. If you would like to discuss the project requirements in detail, please feel free to reach out to me at your convenience. I look forward to the opportunity to work with you and ensure the success of your project. Best regards, Sohail Jamil
$30 USD in 1 day
5.0 (19 reviews)
5.1
5.1
User Avatar
Hi I have 14 years of extensive experience in Data Analysis, Data warehousing ,Business Intelligence and have worked on following technology stack. Power BI, DAX, Power Automate , Power Apps, Azure Synapse Analytics, Azure Data Factory, Azure Data lake , Azure Analysis Services, Azure Data Bricks, Data Warehousing , Business Intelligence , SQL Server , SSIS , SSAS , Excel, Power shell I have completed following certification and find my Transcript details. 1. DP-203 :- Data Engineering on Microsoft Azure 2. DA-100/70-778 :- Analyzing and Visualizing Data with Microsoft Power BI 3. 70-463 :- Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
$140 USD in 7 days
5.0 (8 reviews)
5.0
5.0
User Avatar
Hi there, I am a Data Scientist and am a professional responsible for extracting actionable insights and knowledge from large volumes of Data Visualization. I have over 12-plus years of experience with Power BI, PowerApps, PowerShell, Visual Studio, Power Automation, Microsoft Power BI, Microsoft 365, tableau top priority is to provide high quality work. I am willing to fully devote my time and energy to improve the service offered, with timely, accurate and professional results, Building trust and a long-term relationship with the customer is my main objective. Let's discuss this further via chat, and I'll start your project right now. Thank you. Gdev
$100 USD in 2 days
5.0 (6 reviews)
3.7
3.7
User Avatar
Hi there, I am excited to share my expertise and skills in DAX and PowerQuery, which I have acquired over the past 3 years. I am confident that I can meet your requirements. Ps. After carefully reading the project requirements I can assure you I'm able to get it done within a few hours, contact me to start working right away.
$99 USD in 1 day
5.0 (4 reviews)
3.5
3.5
User Avatar
As an experienced Excel and web developer with expertise in Data Processing and VBA, I understand what is required to solve your problem. I have a deep knowledge of Power Query (M) and have successfully handled similar tasks in the past. My skill set allows me to effectively extract data from various sources, perform necessary transformations, and load it into Excel or web applications. In addition to my technical expertise, I bring a strong commitment to quality and meeting deadlines. I understand that your code needs to work without any problems within the PowerBI service DataMart transformation section for you to receive payment. Rest assured, I carefully verify my work for bugs and inconsistencies before delivering it, ensuring that your calculated column will function flawlessly. Furthermore, our collaboration will be smooth as I actively communicate with my clients - providing regular updates and actively seeking clarifications when necessary. My passion for elegant solutions combined with affordable pricing tailored to your budget makes me a great fit for your project. Let us work together in streamlining your DataMart operations using Power Query in PowerBI Service!
$65 USD in 2 days
4.5 (23 reviews)
3.6
3.6
User Avatar
I fully understand the problem you're encountering and I'm confident in my abilities to deliver a solution swiftly, having extensive experience with Power Query and Power BI. As a clinical research professional, I know the importance of ensuring that data is accurate, structured correctly, and easily accessible. The code will definitely work as expected; but as you said - pay when code works. Don't hesitate to get in touch; I am ready and eager to transform this DAX code into Power Query for you.
$150 USD in 2 days
5.0 (5 reviews)
3.4
3.4
User Avatar
Hi there! Greetings from Wilfred! I am thrilled to express my strong interest in this Creating calculated column in DataMart (Converting DAX code into Power Bi Power Query) project. With my years of experience working as a freelancer, I have honed my skills in SQL, Excel, Visual Basic, Microsoft Access and Data Processing which you indicated are essential for this project. I am eager to learn more about this project. Thank you Possibilitis P. for your time.
$155 USD in 1 day
5.0 (1 review)
2.9
2.9
User Avatar
Hello, As an experienced data professional with over 10 years in data processing, I have gained a deep understanding of various data formats, including the MS Excel Files, CSV Files, TVX Files and Text Files that you mention needing assistance with. I am confident in handling your DAX to PowerQuery conversion for your Power BI project. My expertise with Excel Advance, Advanced Excel with VBA, Macros and Excel-based SQL functions makes me well-suited to process and transform your data effectively. I can adapt these skills to work with PowerQuery confidently. During my time at an electricity distribution company handling massive data volumes of customer allocations and tariff classifications, I honed my abilities in leveraging data processing tools to generate impactful insights. Quality and efficiency are my trademarks; qualities crucial to ensuring your code functions perfectly in the new environment. I am meticulously focused on detail while also focused on delivering solutions punctually. In conclusion, my extensive experience in the field, unique skill set and proven dedication to quality alongside timely project delivery make me the idea candidate for this task. With me on board, you can be confident that your DAX-to-PowerQuery transformations will be executed accurately without any issues. Choose experience and quality; choose me! Thank You! Ahmad
$200 USD in 7 days
5.0 (1 review)
2.8
2.8
User Avatar
With a specialization in Data Processing and profound knowledge of VB, I have developed sophisticated applications in Matlab and Excel over the past 15 years. Precisely, I have expertly utilized PowerQuery to create calculated columns in multiple DataMarts, which aligns perfectly with your project's specifications. My competence in using PowerQuery (M language) will ensure a swift and accurate translation of your DAX code, enabling a smooth transition to PowerBI Service's DataMart transformation section without hitches. Furthermore, my skills extend beyond DataMart configurations. I am well-versed in performing extensive statistical analysis, majorly regression analysis, hypothesis testing and applying data processing techniques. These skills are highly relevant to your project as they'll enable me to not just convert the DAX codes to M-Power Query but also incorporate any necessary data-processing steps that may be essential for crafting efficient calculated columns. Thank you for considering my proposal!
$140 USD in 7 days
5.0 (3 reviews)
2.5
2.5
User Avatar
With my extensive experience in data processing and proficiency in Excel, I am confident that I can effectively convert your DAX code into Power Query in DataMart. I have over two years of experience working as a freelancer on various data-centric projects, which not only honed my skills but also expanded my knowledge base. I understand that the successful conversion of this code is critical for your Power BI reports to work flawlessly. My commitment to delivering accurate and precise work aligns perfectly with this project's need for attention to detail. I assure you that not only will I complete the task swiftly, but the final output will work without any problems. As a freelancer, my primary focus has always been customer satisfaction and building long-term relationships. Hence, hiring me means getting a professional who is not only skilled but also dedicated to making sure your needs are met and your expectations exceeded. Let's execute this task together, ensuring your project progresses smoothly.
$40 USD in 2 days
3.9 (2 reviews)
0.7
0.7
User Avatar
With my in-depth expertise in Power Query (M) and Excel, coupled with my knack for meticulousness, I am your perfect choice to convert your existing DAX code into Power Query for your DataMart project. Over the years, I have honed my skills in translating data-related tasks into precise codes that seamlessly function without any issue. My proficiency in PowerQuery is well-known, which makes me familiar with transforming complex formulas or codes accurately. I understand the crucial role of error-free calculations for effective reporting and I assure you that I'll deliver nothing but Additionally, for any project I undertake, meeting client expectations is a priority. This aligns perfectlywith your requirement that "to get paid, the code must work without any problem." Working collaboratively with clients to understand their business needs completely is a practice that has helped me create impactful solutions several times. Let's discuss your conversion requirements further and create an optimal Power Query solution for your DataMart. Selecting me would ensure a seamless integration of your existing DAX code into Power Query, giving you peace of mind and a smooth workflow.
$50 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello sir, I understand the urgency of converting DAX code into Power Query for DataMart transformation in Power BI Service. As an adept Power Query specialist, I've successfully executed similar conversions, ensuring seamless functionality in DataMart. My expertise guarantees precise code translation and effective implementation within the specified environment. I've successfully created calculated fields in DataMart using Power Query, ensuring reliable performance. Let's discuss your specific requirements, ensuring a swift and error-free conversion. Looking forward to delivering optimal results,
$140 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Greetings Possibilitis P., Good afternoon! I am an expert data analyst with skills including Visual Basic, Microsoft Access, Excel, Data Processing and SQL. I hold an masters degree in data analysis which provides me with the necessary background to handle your project. Having done similar projects, I can deliver quality and superior work at a price we are both comfortable with and within the agreed timeline. Meanwhile, I am currently reviewing your attachment. I will update you shortly in the inbox once you respond to my proposal. Please send a message to discuss more about this project. Your Sincerely, Lincoln
$100 USD in 3 days
0.0 (1 review)
1.0
1.0
User Avatar
Hello I am a skilled full-stack developer. I have strong knowledge of Data Processing. And also I have a good experience in developing Data Processing with Excel. I mastered SQL, Visual Basic, PowerQuery. I am looking forward to hearing from you. Thank you for considering me for this job! I will wait for your response. Have a good time.
$50 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Iam data entry expertsData Entry, Typing and Document Editing Field. I will help you in excel or word data entry. I am here to fulfill your needs. Customer satisfaction is my first priority. "Your success is my Business!"
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
As an experienced software developer with over twelve years in the field, I bring a wealth of knowledge across various technologies, including essential skills such as Microsoft Access, SQL, and Visual Basic. My understanding of these tools will be pivotal in converting your existing DAX code to PowerQuery within the DataMart transformation environment. Moreover, my proficiency in different programming languages and frameworks extends to front-end technologies like React, Vue.js, Angular, and back-end technologies like Node.js, Express.js. This allows me to approach problems from a holistic perspective - ensuring seamless integration of queries when switching between DAX and PowerQuery. In addition to my technical expertise, I understand the importance of a code's reliability for payment purposes. You can trust that all calculations and transformations will work flawlessly as I convert your code's functionality. So let’s work together, with guarantees of quality service and timely delivery, I assure you won’t regret choosing me for this project! Thank you for your consideration.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Ottawa, Canada
5.0
2
Payment method verified
Member since Sep 18, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.