How to get Latest date data.

[Anonymous]

we have 3 visuals (in , out and Existing). we want to show the latest date data.

Ex:  we have the below data, so in powr bi Table visula there sould be method A should be available and in "In" table, "Out" table should be blank and in in existing method A will be visible.

Details	Method	Payment	Date
in	A	100	3/10/2022
Out	Z	1000	3/8/2022
in	D	10	2/8/2022
Out	H	50	2/24/2022

If the latest date is 10th March, then data should be available for the 10. either it could be In or Out or for both. instead of showing all date record.

[amitchandak · Accepted solution]

@Anonymous , You need to use a measure like below in table or use that visual level filter

measure =

var _max = maxx(allselected(Table), Table[Date]) //or use// maxx(all(Table), Table[Date]) 

return

calculate(sum(Table[Payment]), filter(Table, Table[Date] =_max))