Find Jobs
Hire Freelancers

DAX shits minutes calculate - please read all

€8-30 EUR

Đã đóng
Đã đăng vào khoảng 2 tháng trước

€8-30 EUR

Thanh toán khi bàn giao
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)
Mã dự án: 37773164

Về dự án

13 đề xuất
Dự án từ xa
Hoạt động 21 ngày trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
13 freelancer chào giá trung bình €25 EUR cho công việc này
Avatar người dùng
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 trong 3 ngày
4,9 (13 nhận xét)
4,2
4,2
Avatar người dùng
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 trong 1 ngày
4,1 (11 nhận xét)
4,3
4,3
Avatar người dùng
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 trong 1 ngày
5,0 (4 nhận xét)
3,3
3,3
Avatar người dùng
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 trong 7 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
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 trong 1 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
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 trong 1 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
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 trong 7 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
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 trong 1 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
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 trong 7 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
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 trong 1 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
I will describing your requirement into power bi visualization. I have experience in power bi dashboard.
€30 EUR trong 7 ngày
0,0 (0 nhận xét)
0,0
0,0

Về khách hàng

Cờ của ITALY
Pordenone, Italy
0,0
0
Phương thức thanh toán đã xác thực
Thành viên từ thg 2 15, 2024

Xác thực khách hàng

Các công việc khác từ khách hàng này

DAX shits minutes calculate - please read all -- 2
€2-6 EUR / hour
Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.