Find Jobs
Hire Freelancers

DAX shits minutes calculate - please read all

€8-30 EUR

已关闭
已发布3 个月前

€8-30 EUR

货到付款
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)
项目 ID: 37773164

关于此项目

13提案
远程项目
活跃2 个月前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
13威客以平均价€25 EUR来参与此工作竞价
用户头像
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 在3天之内
4.9 (13条评论)
4.2
4.2
用户头像
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 在1天之内
4.1 (11条评论)
4.3
4.3
用户头像
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 在1天之内
5.0 (4条评论)
3.3
3.3
用户头像
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 在7天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在7天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在7天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
I will describing your requirement into power bi visualization. I have experience in power bi dashboard.
€30 EUR 在7天之内
0.0 (0条评论)
0.0
0.0

关于客户

ITALY的国旗
Pordenone, Italy
0.0
0
付款方式已验证
会员自2月 15, 2024起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。