Filter older entries by date

[ovetteabejuela]

Hi,

Need help on a logic to only show the "latest update" for example:

Below on the left is the raw data, I want a filter that would then give me a result like the one showed on the right

EDIT: I need a DAX filter because the raw data I mentioned is already a result of two related tables.

Raw Data		Desired Output
Start	End		Start	End
1/1/2017	1/31/2017		1/1/2017	2/18/2017
1/1/2017	2/5/2017		3/12/2017	5/1/2017
1/1/2017	2/18/2017		5/9/2017	7/3/2017
3/12/2017	3/25/2017
3/12/2017	5/1/2017
5/9/2017	5/10/2017
5/9/2017	5/30/2017
5/9/2017	6/11/2017
5/9/2017	7/3/2017

[v-sihou-msft · Accepted solution]

@ovetteabejuela

You can't directly use a filter to achieve this output.

You can either create a measure to get last date: 

LastUpdateDate=MAX(Table[End])

Or you can create a calculated table. 

Table = SUMMARIZE(Table,Table[Start],"latest update",MAX(Table[End]))

You can also achieve it via Power Query approach:

Regards,

[ovetteabejuela]

Thanks @v-sihou-msft , this is awesome.