Power BI [résolu] Multiples opérations via Power Query

let
    Source = Excel.Workbook(File.Contents(" ADD YOUR FILE TARGET"), null, true),
    Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    #"Added Index" = Table.AddIndexColumn(Sheet, "Index", 1, 1, Int64.Type),
    Position = List.PositionOf(#"Added Index"[Column2], "Assignment Group"),
    Header = Table.RemoveColumns(Table.Combine(Table.AddColumn(Table.SelectRows(#"Added Index", each [Index] > Position and [Index] < Position + 5), "Header", each Table.FromRecords({_}))[Header]), "Index"),
    #"Listed ColName" = List.Transform (List.Transform(Table.ToColumns(Table.DemoteHeaders(Header)), List.RemoveNulls),  each if List.Count(_) = 2 then _ else  List.InsertRange(_, 1, {"Empty " & _{0}})  ),
    #"Promoted Header" = Table.RenameColumns(Table.SelectRows(#"Added Index", each [Index] > Position + 7), #"Listed ColName"),
    #"ColName to keep" = {"Employee Name", "Pay Code", "Work Date" , "Hours"},
    #"Selected Columns" = Table.SelectColumns(#"Promoted Header" , #"ColName to keep"),
    #"Filled Down" = Table.ReplaceValue(Table.SelectRows(Table.FillDown(#"Selected Columns",{"Employee Name"}), each [Pay Code] <> null and [Hours] <> null and [Hours] <> 0)," (cont.)","",Replacer.ReplaceText,{"Employee Name"}),
    #"Removed Meal" = Table.SelectRows(#"Filled Down", each ([Pay Code] <> "Meal")),
    #"Sum per Pay Code" = Table.Group(#"Removed Meal", {"Employee Name", "Work Date", "Pay Code"}, {{"Hours", each List.Sum(_[Hours])}}),
    #"Table w/o Holiday" = Table.SelectRows(#"Sum per Pay Code",  each not Text.StartsWith([Pay Code], "Holiday")),
    #"Table w/ Holiday" = Table.ExpandRecordColumn(Table.SelectColumns(Table.AddColumn(Table.Group(Table.SelectRows(#"Sum per Pay Code", each Text.StartsWith([Pay Code], "Holiday")), {"Employee Name", "Work Date"}, {{"All data", each Table.AddIndexColumn(_, "Index",0)}}), "Diff",
each let
Alldata = [All data],
PreRows = Table.AddColumn(Alldata, "Previous", each  try if Alldata[Hours] {[Index] - 1 } - [Hours] > 0 then Alldata[Hours] {[Index] - 1 } - [Hours]  else [Hours] otherwise [Hours] ),
Select = Table.AddColumn(PreRows, "Custom", each try if PreRows[PreRows]{1} = PreRows[Hours]{1}  then PreRows[Pay Code]{1} else PreRows[Pay Code]{0} otherwise [Pay Code] ),
FinalStep = Table.SelectColumns(Table.RenameColumns(Table.SelectColumns(Select, {"Employee Name", "Work Date", "Previous", "Custom"}), {{"Previous", "Hours"},{"Custom", "Pay Code"}}), Table.ColumnNames(#"Table w/o Holiday")),
Result = try FinalStep{1} otherwise FinalStep{0}
in Result),"Diff"), "Diff", Table.ColumnNames(#"Table w/o Holiday")),
    #"Combine Tables" = Table.TransformColumnTypes(Table.Sort(Table.Combine({#"Table w/o Holiday", #"Table w/ Holiday"}),{{"Employee Name", Order.Ascending}, {"Work Date", Order.Ascending}, {"Pay Code", Order.Ascending}}),{{"Work Date", type date}}),
    #"Added Week N°" = Table.AddColumn(#"Combine Tables", "Week N°", each Date.WeekOfYear([Work Date], Day.Monday))
in
    #"Added Week N°"