Problem when expandingRecordColumn

[PatrickByGecko]

Hi,

I got few columns, [COLLABORATEURId], [CODE PROJETId],[DATE FIN],[FIELD4],[FIELD5] etc..

I grouped this table on [COLLABORATEURId] and [CODE PROJETId] with a condition on [DATE FIN] so as to supress duplicates records on [COLLABORATEURId] and [CODE PROJETId] =>

#"Grouped Rows"= Table.Group(#"InitialTable", {"COLLABORATEURId", "CODE PROJETId"}, {{"COLLABPROJET", each List.Max([DATE FIN])}})

Doing that I get only two columns [COLLABORATEURId] and [CODE PROJETId].

But after that,  I don't succeed to get back all my columns [COLLABORATEURId], [CODE PROJETId],[DATE FIN],[FIELD4],[FIELD5] etc.. doing a Table.ExpandRecordColumn on #"Grouped Rows"

Can you help?

[PatrickByGecko]

I'm sorry; I can do both as you Shown before but when I want after to expand the columns the duplicates fields [CODE PROJETId],[DATE FIN] are always there.

[PatrickByGecko · Accepted solution]

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!

🙂

[parry2k]

@PatrickByGecko you can add multiple aggregations for group and one can be all rows 

[PatrickByGecko]

Thanks for your help but underneath if I chose "all Rows" I can't do on the same time my condition on "Max" [Date Fin] for suppressing the duplicates records as I said before.

How can I manage both, on the same time?