let
Source = OData.Feed("https://bridge-online.cloud/acme-gripp-crm/odata4", null, [Implementation="2.0"]),
#"GrippCrm.DEFAULT.Hours@grp_table" = Source{[Name="GrippCrm.DEFAULT.Hours@grp",Signature="table"]}[Data],
#"Removed Other Columns" = Table.SelectColumns(#"GrippCrm.DEFAULT.Hours@grp_table",{"id", "date_date", "status_id", "description", "amount", "employee_id", "offerprojectbase_id", "offerprojectbase_searchname", "offerprojectline_id", "offerprojectline_searchname"}),
#"Changed Type" = Table.TransformColumnTypes(#"Removed Other Columns",{{"date_date", type date}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"offerprojectbase_searchname", "offerprojectline_searchname", "status_id", "id"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"date_date", "date"}}),
#"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each [date] > #date(2022, 9, 25)),
#"Inserted Merged Column" = Table.AddColumn(#"Filtered Rows", "EmployeeRateKey", each Text.Combine({Text.From([employee_id], "nl-NL"), "-", Text.From([date], "nl-NL")}), type text)
in
#"Inserted Merged Column"