Get the Latest Result based on Date with the Duplicated Customers

[Chanleakna123]

hi , i have below submission result. 

and i would like to see only the last submission if i have duplicated data based on Date , Time ,

So it mean  when i filter any Date , the duplicated Customers show only 1 Customer with the latest submission. 

if i filter any date which is no duplicated customers , show the Customer there. 

[ryan_mayu]

@Chanleakna123 

you can create a new table

new table = 
VAR tbl=SUMMARIZE('Table (3)','Table (3)'[customer code],'Table (3)'[customername],'Table (3)'[submission date],"time",max('Table (3)'[Time]))
return ADDCOLUMNS(tbl,"stock",MINX(FILTER('Table (3)','Table (3)'[Time]=EARLIER([time])&&'Table (3)'[customer code]=EARLIER('Table (3)'[customer code])&&'Table (3)'[submission date]=EARLIER('Table (3)'[submission date])),'Table (3)'[stock]))