Filter on highest ID based on a date field.

[Anonymous]

I have a table with some values

Date	Product_ID	Customer	Ord_ID
01.02.2019 00:00:00	3050-1	001	1
01.02.2019 00:00:00	3050-1	001	1
01.02.2019 00:00:00	3050-1	001	2
01.02.2019 00:00:00	3050-1	001	2

I need something that returns the highest Ord_ID vaules only based on the same date and time, so I get this output.

01.02.2019 00:00:00	3050-1	001	2
01.02.2019 00:00:00	3050-1	001	2

Is there a way to accomplish this? My table has about 1.000.000 rows and sometimes duplicates occurs, but allways on the same date. 

Suggestions? 🙂 Please help me.

[amitchandak · Accepted solution]

You can try EARLIER. Refer

https://community.powerbi.com/t5/Desktop/Explanation-of-the-EARLIER-formula/td-p/529469

https://docs.microsoft.com/en-us/dax/earlier-function-dax

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601