Power BI DAX formula

$10-30 USD

Terminado

Publicado

hace alrededor de 4 años

$10-30 USD

Pagado a la entrega

I have data in Power BI that is weekly submitted summarized data, we do not overwrite the summary data from the previous week, we keep adding the new week. I need to be able to show in a report only the latest summary data for a value in another column in the same table. In attached image you can see a list of Event Names where each has a set of records. The dates are the Summary File date for each of the Summary Files that have been uploaded over time (weekly). I want to be able to see only the latest Summary File rows for each event. So I need the report to reflect only the rows highlighted in yellow. My columns are: EventName & SummaryDate For each EventName return only the list of rows where SummaryDate is latest date. Hope it's clear. Please specify what other information you need from me. Thank you.

Power BI

ID del proyecto: 23948066

Información sobre el proyecto

13 propuestas

Proyecto remoto

Activo hace 4 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@antoinepal

Hello, I can build this you want in Power BI as i am an experienced Power BI developer with over 8 years in the field. Please check my pirtfolio to see my work. Thanks!

$30 USD en 1 día

5,0

(53 comentarios)

6,2

13 freelancers están ofertando un promedio de $22 USD por este trabajo

@nikhilgupta84

Data Scientist/Analytics Consultant with over 13 years of industry experience. I have worked in various domains like Retail, Banking, Insurance and Healthcare (Real World evidence). I have been invoved into end-to-end analytics project execution which involves the following taks: a) Data Management (Processing, Cleaning, Transfomation) b) Data Reporting/Dashboarding (BI) c) Data Analysis/Modeling To accomplish the above mentioned tasks, I am extensively using the following tools: - SAS - SPSS - R - Python - Power BI - Tableau - SQL - MS Excel - MS Access bid may change depending on the work

$30 USD en 1 día

5,0

(7 comentarios)

4,5

@aimefx

Hi, I am an expert in Power BI and have completed 110+ Power BI. I can create the required DAX formula for you. please send me a message to discuss further. Thanks.

$30 USD en 1 día

5,0

(14 comentarios)

4,7

@jayprihar69

Hello, I have gone through your requirment, where you want to see only the latest Summary File rows for each event. Based on this you need the report to reflect only the rows highlighted in yellow. I am interested in this work, as I am an experienced Power BI developer having 5 years of experience. To move further please provide the excel sheet so that I can review it in real time & provide you my further input on time & cost. Looking forward to your reply. Thanks & Regards ABP Please note that the given bid amount & timeline are place holder & do not consider it as final bid amount.

$30 USD en 7 días

5,0

(2 comentarios)

3,8

@ibrahimanjum330

Hi, I am Ibrahim and I am an expert in DAX, please tell me the details of the measure you want me to create in powerbi. Regards, Ibrahim Anjum

$10 USD en 2 días

5,0

(3 comentarios)

1,9

@nitinshuklaESS

We have already used this kind of scenario in some of our project, so we can easily replicate your issue.

$20 USD en 1 día

5,0

(2 comentarios)

1,3

@bakulpatela1

Hi, I am an experienced data/Business analyst and expert in SQL, Access, Excel, Google sheets, Power BI, Tableau, Office365, SQL server analytics services. It is fairly easy and can do in an hour or so. Please let me know if you need any help. Thanks, Bakul

$25 USD en 1 día

5,0

(1 comentario)

1,4

@mahendra8055

Hi Team, Customer centric project management professional with an experience of 12years dedicated in providing the best service possible to the clients and to establish a healthy, continuous and successful business relationship by meeting delivery requirements on time. Give an opportunity to work on your project. I have 10yrs of hands on experience on MS-Excel, Word, PowerBI, PPT, Account Management. Thanks, Mahendra.

$15 USD en 7 días

0,0

(0 comentarios)

0,0

@kwowag

I am one of the top producers of dashboards in my organisation. I use a range of Dax functions to create measures and calculations for rich insights into your data. I offer excellent value for money.

$26 USD en 2 días

0,0

(0 comentarios)

0,0

@mudasssarshahid

I have been working with Power Pivot and Power BI for the last 5 years now. I think I now how to handle your situation.

$10 USD en 7 días

0,0

(0 comentarios)

0,0

@ginjin

Hi There, Hope you are doing well. I am working on power bi from last 3 years. I can help you achieve your desired requirement using power bi. You can check our portfolio on given link below. Freelancer : https://www.freelancer.com/u/ginjin?w=f let's discuss your requirements in details. thanks and regards

$10 USD en 7 días