Bonjour à tous !
Une proposition ?
let
Source = Excel.CurrentWorkbook(){[Name="t_INITIAL"]}[Content],
#"Type modifié" = Table.TransformColumnTypes(Source,{{"FICHIER", type text}, {"LIBELLE", type text}, {"NOM", type text}, {"DATE DEBUT", type datetime}, {"DATE FIN", type datetime}, {"MONTANT", Int64.Type}}),
GroupBy = Table.Group(#"Type modifié", {"FICHIER"}, {{"tbl", each _, type table [FICHIER=nullable text, LIBELLE=nullable text, NOM=nullable text, DATE DEBUT=nullable datetime, DATE FIN=nullable datetime, MONTANT=nullable number]}, {"Cumul Fichier", each List.Sum([MONTANT]), type nullable number}}),
Expand = Table.ExpandTableColumn(GroupBy, "tbl", List.Skip(Table.ColumnNames(Source)))
in
Expand