Power BI DAX formula

$10-30 USD

Completed

Posted

about 4 years ago

$10-30 USD

Paid on delivery

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

Project ID: 23948066

About the project

13 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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 in 1 day

5.0

(53 reviews)

6.2

13 freelancers are bidding on average $22 USD for this job

@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 in 1 day

5.0

(7 reviews)

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 in 1 day

5.0

(14 reviews)

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 in 7 days

5.0

(2 reviews)

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 in 2 days

5.0

(3 reviews)

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 in 1 day

5.0

(2 reviews)

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 in 1 day

5.0

(1 review)

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 in 7 days

0.0

(0 reviews)

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 in 2 days

0.0

(0 reviews)

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 in 7 days

0.0

(0 reviews)

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 in 7 days