Find Jobs
Hire Freelancers

DAX shits minutes calculate - please read all

€8-30 EUR

Closed
Posted 3 months ago

€8-30 EUR

Paid on delivery
I have a statement sheet where there are for each machine start time and end time of the event. I created two columns (for only hour) called Start and End In PBI I created a Shift column to specify if the shift is Morning / Afternoon / Night. However, there are rows where the statement starts in the morning and ends in the afternoon (e.g. row 159 - start 1:56 pm - end 2:15:59 pm). I need to calculate the afternoon accrual minutes and the morning accrual minutes. The shifts are: morning 06.00 - 13.59 afternoon 14.00 - 21.59 night 22.00 - 05.59 The purpose is to figure out, for each type (code on type column) the minutes per shift morning, afternoon, night for each day. The ideal result is a table report with a day column, shift column, type column, minute column that should represent the sum of minutes for the type (e.g., type 1 - morning shift - sum of minutes of type 1 for that day for morning shift). I provide xls file. I need the final powerbi file Translated with [login to view URL] (free version)
Project ID: 37773164

About the project

13 proposals
Remote project
Active 1 mo 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
13 freelancers are bidding on average €25 EUR for this job
User Avatar
Dear Gino P., Hope my message finds you well. With an experience of more than five years, I am writing to express my strong interest in the project titled "DAX shits minutes calculate - please read all"and to write my enthusiasm for the opportunity. With a proven track record in data analysis, and visualization, I am well-equipped to deliver valuable insights and actionable reports. My skills in Power BI encompass data modeling, DAX scripting, and creating interactive dashboards. I have a deep understanding of data integration, having successfully connected Power BI to various data sources, including SQL databases, Excel, and online services. I have knowledge and experience of handling complex data models to maintain data integrity and provide best data visualizations. Meanwhile I am reviewing attach and we will discuss ... Sincerely, Sajid Hussain
€21 EUR in 3 days
4.9 (13 reviews)
4.2
4.2
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.
€19 EUR in 1 day
4.1 (11 reviews)
4.3
4.3
User Avatar
Hi there. ⭐⭐ I am a full stack Developer ⭐⭐ with experience in PowerBI, Javascript, PHP, AWS, MY SQL, Bot Developement, Web, Machine Learning (ML), PYTHON, Deep Learning and Communications. I have worked with many similar projects as i have a team of enthusiastic developers. We strive to give our best. Please contact to discuss in detail.
€30 EUR in 1 day
5.0 (4 reviews)
3.3
3.3
User Avatar
As a seasoned and dedicated Power BI professional, I am confident in my ability to successfully complete your project. My prior experience working with complex data analyses, including shift calculations like the one you need, makes me an ideal candidate for this task. By properly utilizing functions and formulas like DAX language and IF statements, I will seamlessly calculate the morning and afternoon accrual minutes for each type and shift. Alongside my technical aptitude, I bring a detail-oriented work ethic and fierce commitment to delivering quality results while being mindful of your timelines. Given my availability and readiness to tackle challenging projects head-on, I assure you of a powerbi file that surpasses your expectations. Choosing me means gaining a partner who not only generates accurate reports but also prioritizes your objectives and values effective communication throughout the process. Additionally, my dedication extends beyond project completion; as we wrap up, you can rely on my unwavering commitment to providing free revisions till you are fully satisfied. Together, let's turn your data into actionable insights.
€19 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
As an experienced Power BI expert, I understand the project requirements you explained regarding the calculation of morning/afternoon accrual minutes from your statement sheet. I have successfully delivered numerous projects handling complex calculations, data manipulation, and generating insightful reports. I am confident in my abilities to analyze the shifts efficiently and derive comprehensive tables, organizing them by day, shift, and code types, with minute breakdowns. Additionally, my skills span beyond Power BI. I am well-versed in Python and Excel VBA—precisely the expertise that's needed to approach your task effectively. With this versatility, I will ensure smooth data extraction from your xls file combined with any additional computation required for your report generation. Finally, what sets me apart is not just my skills but my commitment to ensuring client satisfaction. Not only do I work diligently and maintain constant communication throughout the project lifecycle , but I don't ask for upfront payments and simply require your approval before releasing funds. Let's collaborate and achieve a quality result together! Reach out to me at any time as I'm available 24X7 for you!
€19 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I specialize in leveraging Power BI to transform your raw business data into actionable insights, empowering informed decision-making. My proposal outlines a comprehensive approach to deliver a customized Power BI solution tailored to your specific needs. 1. Needs Assessment: Conduct a thorough analysis of your business requirements and data sources. Identify key performance indicators (KPIs) to ensure the visualization aligns with your strategic objectives. 2. Data Modeling: Design and implement an effective data model to ensure accurate representation of your business data. Clean and transform data for optimal visualization and analysis. Dashboard Development: 3. Create interactive and visually appealing dashboards that provide a holistic view of your business metrics. Incorporate user-friendly features to facilitate easy exploration of data trends
€19 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
More than 5 years if experience in Power BI and overall 10 years experience in IT industry. We can connect to discuss and resolve your issue.
€19 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Salve signore, Siamo una società di sviluppo indiana qui. abbiamo controllato i dettagli che hai pubblicato qui e desideriamo maggiori chiarimenti, quindi inviaci un messaggio per discuterne di più, quindi potremo procedere. Grazie....
€10 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear, I'm ready to tackle your Power BI project, focusing on calculating accrual minutes per shift (Morning, Afternoon, Night) based on machine event times. I understand you've encountered issues with events spanning multiple shifts and need accurate minutes allocation for each shift. Solution Overview: I'll use Power BI to analyze your statement sheet, creating a dynamic solution that: Splits event durations across shifts when necessary. Accurately calculates morning, afternoon, and night accrual minutes. Aggregates minutes by type and shift for each day. Approach: Data Preparation: Import your XLS file and create calculated columns to identify shift overlaps. DAX Formulas: Use DAX to calculate split times and accrual minutes for each shift. Visualization: Develop a table report with Day, Shift, Type, and Minutes columns to display aggregated data. Deliverable: A Power BI file (.pbix) with a comprehensive solution, enabling easy analysis and reporting of shift-based accrual minutes by machine type and day. Budget and Timeline: I propose a fee that respects your budget, aiming for swift and efficient delivery. Let's discuss further to finalize these details. Thank you for considering my proposal. I look forward to delivering a solution that meets your specific needs and exceeds expectations. Best regards, Dean
€19 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
For this problem statement I would use a summarize DAX function to create the desire table you needed. This DAX will solve your problem and should be quick. Summarize( group by type, group by day. group by shift, sum(minute column), "Total minutes") In the above Total minutes will be the new column that will have the total minutes for that day for that shift and for that type.
€15 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I will describing your requirement into power bi visualization. I have experience in power bi dashboard.
€30 EUR in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of ITALY
Pordenone, Italy
0.0
0
Payment method verified
Member since Feb 15, 2024

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.