How I can filter the row with Max date and time? all other fields are same just Last time field is different I want to show with Max date time.

[umerfa]

[QFabian · Accepted solution]

Hi @umerfa, please check if this works for you :

Data:
Load distinct
[Audit Date],
[Stock Part],
[Long Desc],
[Short Desc],
[Pallet Qty],
[Next PO],
[Audit User]
From YourSource;

left join
Load
[Audit Date],
[Stock Part],
[Long Desc],
[Short Desc],
[Pallet Qty],
[Next PO],
[Audit User],
max(Time) as Time
From YourSource
Group By
[Audit Date],
[Stock Part],
[Long Desc],
[Short Desc],
[Pallet Qty],
[Next PO],
[Audit User];

[umerfa]

Hi QFabian, this works for me, Thank you so much

[QFabian]

thanks you @umerfa