cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sv12 Regular Visitor
Regular Visitor

Data Filtering

Hi,

I am trying to filter the below table so that I am left with 1 record per name with most recent update.

 

Example: In the below case; I would be left with the highlighted rows as desired output.

NameUpdateDate
MarkInitiall Call1/1/2019
MarkFollow up call1/5/2019
AlexInitial Call1/2/2019
AlexFollow up call1/3/2019
AlexPaper work1/4/2019

 

Any thoughts on how do I achieve this in Power BI?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Data Filtering

Hi @sv12 ,

 

You can create a calculated table using DAX below.

 

Table = FILTER(Table1,Table1[Date]=CALCULATE(MAX(Table1[Date]),FILTER(Table1,Table1[Name]=EARLIER(Table1[Name]))))

38.png

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Highlighted
Super User
Super User

Re: Data Filtering

Hi @sv12 

Create a new calculated table: 

FILTER (
    Table1,
    Table1[Date]
        = CALCULATE ( MAX ( Table1[Date] ), ALLEXCEPT ( Table1, Table1[Date] ) )
)
Community Support Team
Community Support Team

Re: Data Filtering

Hi @sv12 ,

 

You can create a calculated table using DAX below.

 

Table = FILTER(Table1,Table1[Date]=CALCULATE(MAX(Table1[Date]),FILTER(Table1,Table1[Name]=EARLIER(Table1[Name]))))

38.png

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 128 members 1,634 guests
Please welcome our newest community members: