let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("fZNLa+MwFIX/ivA6M1ivK2m0KmkW2bQlGZhFCcU4IggcOcTuw/9+JMWO7Y48K18jnY+jc+99fc045UrgbJXtdz84VbHqmtac0eZiy/D3MxQoHKDssPIKwhiI+LvK+kvhg8MVmjMuNWqK86UyqDVfrUaezIQAjR5rZ24I4FymEMQXLM9VuGwq+2GuHfWlLU6ublpbNho9u8o6o9HX2yfhTPY8hVme4NHAw4ILjXbm+O6OhSu76Ci81UN2pjh2kQE050ATDOYLrrBgy562D+vfdV0tueNK0iFiIdRSxGSMGLyVRD4Ex3www6MXX27Pl/ramuO+LVrz66Fs/YFGNw9UzF4ZyKmkCOnJdEYeGKMWJ7S017KZNrSdhmF4NJeq7vS/LJJgsZ7FZ2nvNxPePF2gDMsUSfoCchwCmJLsyRXVxp18m8zVutMEPMeCAJnAqoglTI1YPmEY03cfcjV2Xw3dX14wOum+lOy+ksCXFGxU+P3CCbORQgEw/z4kT+ZTo5eqcCHO+YQorOIjv7PihEAeFvk/rBkJMIUEKc6LIMpHuK6dM2Fgbduhvbl+2NLnZ5tFqDegZMpeSIMIoNKP3uZlux6GF8u7TiXWm/FBxwfdTaZGGUvIoJep3Mfx/OdtIvW7dJfyhFQMUu90LoTscPgL", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, #"SR ID" = _t, #"Work Item Type" = _t, #"Title 1" = _t, Tags = _t]),
#"Grouped Rows" = Table.Group(Source, {"Work Item Type"}, {{"rows", each _, type table [ID=nullable text, SR ID=nullable text, Work Item Type=nullable text, Title 1=nullable text, Tags=nullable text]}},GroupKind.Local,(x,y)=>Number.From(x=y)),
#"Added Custom" = Table.AddColumn(#"Grouped Rows", "Parent ID", each [rows]{0}[ID]),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "Latest Tag", each List.Last(Text.Split(Text.Combine([rows][Tags],";"),";"))),
#"Removed Columns" = Table.RemoveColumns(#"Added Custom1",{"Work Item Type"}),
#"Expanded rows" = Table.ExpandTableColumn(#"Removed Columns", "rows", {"ID", "SR ID", "Work Item Type", "Title 1", "Tags"}, {"ID", "SR ID", "Work Item Type", "Title 1", "Tags"})
in
#"Expanded rows"
How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done". Once you examined the code, replace the entire Source step with your own source.
Obligatory shoutout to @ImkeF Table.Group: Exploring the 5th element in Power BI and Power Query –
