Power BI DAX formula

$10-30 USD

已完成

已发布

大约 4 年前

$10-30 USD

货到付款

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: 23948066

关于此项目

13提案

远程项目

活跃4 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@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 在1天之内

5.0

(53条评论)

6.2

13威客以平均价$22 USD来参与此工作竞价

@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 在1天之内

5.0

(7条评论)

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 在1天之内

5.0

(14条评论)

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 在7天之内

5.0

(2条评论)

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 在2天之内

5.0

(3条评论)

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 在1天之内

5.0

(2条评论)

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 在1天之内

5.0

(1条评论)

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 在7天之内

0.0

(0条评论)

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 在2天之内

0.0

(0条评论)

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 在7天之内

0.0

(0条评论)

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 在7天之内