Completed

Power BI DAX formula

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.

Skills: Power BI

See more: power bi visual, power bi, desenvolvedor freelancer power bi microsoft, dax language training, dax syntax, power bi tutorial, power bi dax functions pdf, power bi dax functions with examples pdf, dax query examples, important dax functions in power bi, dax functions in ssas, freelance power bi, informatico freelance power bi excel, power bi freelance, excel power bi, power bi compare dates, power bi forecasting formula, power bi dax functions list, power bi load multiple files, power bi import multiple files

About the Employer:
( 5 reviews ) Dubai, United Arab Emirates

Project ID: #23948066

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
(13 Reviews)
5.2

14 freelancers are bidding on average $23 for this job

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
(8 Reviews)
4.0
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 i More

$30 USD in 7 days
(1 Review)
2.7
SShtv

Hello I am interested in your proposal and I am ready to solve your task. I have a large and successful hands-on experience in processing and analyzing data in Excel and Power Bi, as well as visualizing the data and co More

$30 USD in 2 days
(1 Review)
1.0
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 rel More

$15 USD in 7 days
(0 Reviews)
0.0
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
(0 Reviews)
0.0
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 More

$30 USD in 1 day
(0 Reviews)
0.0
culturebrick

in report level filter select advance filter as top n as date and select 1 date. if would automatically filter the top date Everytime. let me know if it's clear to you

$30 USD in 1 day
(0 Reviews)
0.0
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
(0 Reviews)
0.0
$25 USD in 1 day
(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 Reviews)
0.0
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 More

$25 USD in 1 day
(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 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://w More

$10 USD in 7 days
(0 Reviews)
0.0