Forum Discussion
Solved
Filter - Last Submission Date
Hello, I have a query comes from Excel. I need to filter only the data whcih has the last submission date. Below is the table for example. 1A, 1B & 1C has submisison in Sep & Jul. 1A & 1C has...
EbyEaso OK, the try:
let Source = SharePoint.Tables("https://myselfsharepoint.com/sites/programs-myself/", [Implementation=null, ApiVersion=15]), #"0eba12ed-d2f6-4bed-a89a-84d46f80e14a" = Source{[Id="0eba12ed-d2f6-4bed-a89a-84d46f80e14a"]}[Items], #"Changed Type" = Table.TransformColumnTypes(#"0eba12ed-d2f6-4bed-a89a-84d46f80e14a",{{"Student ID", type text}, {"Submit Date", type date}}), #"Grouped Rows" = Table.Group(#"Changed Type", {"Student ID"}, {{"Submit Date", each List.Max([Submit Date]), type nullable date}}) in #"Grouped Rows"
EbyEaso You would have to add an aggregation for them in your Group by. Just click the gear icon next to that step in Applied steps.
Greg_Deckler Alright. Noted. Thank Yoy much. Appreciate it.