xlogI125 https://blog.hatena.ne.jp/xlogI125/ xlogI125’s blog https://dy100ms.hatenadiary.jp/ Power Query Excel Table.Distinct, Table.NestedJoin, Table.TransformRows, Table.Sort, Table.First, Table.FromRecordsの組み合わせを考える。Table.Groupとの違いは未確認。 クエリ1, 2, 3 クエリ1: 元のテーブル // クエリ1 詳細エディター Table.FromRows( { {"A", "2020/1/1", 1, "a"}, {"A", "2020/2/2", 2, "b"}, {"A", "2020/3/3", 3, "c"}, {"A", "2020/4/4", 4, "d"}, {"A",… 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fdy100ms.hatenadiary.jp%2Fentry%2F2026%2F01%2F21%2F000000" title="Power Query: 重複削除の際に最新日付を残す - xlogI125’s blog" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> Hatena Blog https://hatena.blog 2026-01-21 00:00:00 rich https://dy100ms.hatenadiary.jp/entry/2026/01/21/000000 1.0 100%