Forum Discussion
PatrickByGecko
Helper V
Helper VTable.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!
🙂
Ashish_Mathur
Super User
Super UserYou are welcome. You just have to click on the icon in the header and select the fields that you want to expand.
PatrickByGeckoHelper V
Helper VHi Ashish
There is nothing to expand when i click these ways, have a look =>
- Ashish_Mathur
I cannot help you by looking at screenshots. Read my solution carefully again and retry.