Power BI DAX formula

$10-30 USD

Concluído

Publicado

há aproximadamente 4 anos

$10-30 USD

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

Sobre o projeto

13 propostas

Projeto remoto

Ativo há 4 anos

Quer ganhar algum dinheiro?

Endereço de e-mail

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

Concedido 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 em 1 dia

5,0

(53 avaliações)

6,2

13 freelancers estão ofertando em média $22 USD for esse trabalho

@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 em 1 dia

5,0

(7 avaliações)

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 em 1 dia

5,0

(14 avaliações)

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 em 7 dias

5,0

(2 avaliações)

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 em 2 dias

5,0

(3 avaliações)

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 em 1 dia

5,0

(2 avaliações)

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 em 1 dia

5,0

(1 avaliação)

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 em 7 dias

0,0

(0 avaliações)

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 em 2 dias

0,0

(0 avaliações)

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 em 7 dias

0,0

(0 avaliações)

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 em 7 dias