Forum Discussion
Filter on highest ID based on a date field.
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.
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
1 Reply
- amitchandak
Super User
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