Forum Discussion
Solved
Table.Distinct power query with a condition
Hello I speak about power queries on desktop power bi. Here is my table records [Field1 = "A", Field2 = "1", Field3= 20231201], [Field1 = "A", Field2 = "1", Field3= 20240101], [Field1 = "B", Fi...
Hi
I Found by myself.
The solutions proposed with grouping and expanding rows can't suppress duplicates fields.
We have to
- sort [COLLABORATEURId], [CODE PROJETId] [DATE FIN] on descending [DATE FIN] (because I want to keep only Max [DATE FIN] for duplicates [COLLABORATEURId], [CODE PROJETId]
- and then do a Table.Distinct
It works fine!
🙂
And please don't forget I'm using Power BI Desktop not excel.