Consider data based on latest date in Power BI editor

[shansakhi]

Hi All,
Need your assitance in Power BI to consider Data based on latest date.
below is the Input table where multiple dates are available for respective Bus No and Sec.. I want to consider data for latest date for these Bus no.

Book1
	H	I	J	K	L	M	N	O	P
3	Input					Outout
4	Bus No	Sec	Dep_Date	Pax No		Bus No	Sec	Dep_Date	Pax No
5	101	AB	2-Dec-22	150		101	AB	15-Sep-24	100
6	101	AB	15-Jan-23	110		103	XX	12-Dec-23	202
7	101	AB	18-Mar-23	180
8	101	AB	15-Sep-24	100
9	103	XX	18-Dec-22	50
10	103	XX	10-Mar-23	75
11	103	XX	12-Dec-23	202
Sheet1

 

[RoryA]

Simple way is to create a separate query that groups on Bus No and Max of the Dep_Date. Then merge that to the main query with an inner join (only matching records) on both Bus No and Dep_Date.

 

[shansakhi]

Thank you for the hint.