Forum Discussion
Solved
Grouping issue
Hi Community I have a table like this one below Required Action Input Date Test Grade Overall Action Unit Reference Estate Test NONE 06/07/2023 D N 65335 Cleaning NONE 23/06...
You can use this as your Group step
= Table.ExpandRecordColumn(Table.Group(#"Changed Type", {"Unit Reference", "Estate Test"}, {{"Input Date", each List.Max([Input Date])}, {"All", each Table.Max(_, {"Input Date"})[[Test Grade], [Required Action]]}}), "All", {"Test Grade", "Required Action"}, {"Test Grade", "Required Action"})
Works perfectly thank you😀