Find Jobs
Hire Freelancers

DAX shits minutes calculate - please read all

€8-30 EUR

Fechado
Publicado há 3 meses

€8-30 EUR

Pago na entrega
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 do Projeto: 37773164

Sobre o projeto

13 propostas
Projeto remoto
Ativo há 1 mês

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
13 freelancers estão ofertando em média €25 EUR for esse trabalho
Avatar do Usuário
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 em 3 dias
4,9 (13 avaliações)
4,2
4,2
Avatar do Usuário
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 em 1 dia
4,1 (11 avaliações)
4,3
4,3
Avatar do Usuário
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 em 1 dia
5,0 (4 avaliações)
3,3
3,3
Avatar do Usuário
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 em 7 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 7 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 7 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I will describing your requirement into power bi visualization. I have experience in power bi dashboard.
€30 EUR em 7 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) ITALY
Pordenone, Italy
0,0
0
Método de pagamento verificado
Membro desde fev. 15, 2024

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.