{"id":38,"date":"2016-08-24T09:59:00","date_gmt":"2016-08-24T09:59:00","guid":{"rendered":"http:\/\/coding.agust.org\/?p=38"},"modified":"2016-11-25T15:21:53","modified_gmt":"2016-11-25T15:21:53","slug":"first-value-of-grouped-values","status":"publish","type":"post","link":"https:\/\/coding.agust.org\/index.php\/2016\/08\/24\/first-value-of-grouped-values\/","title":{"rendered":"First value of grouped values"},"content":{"rendered":"<p>Here is how to group by a field in PowerQuery and list the first value of another column:<\/p>\n<script src=\"https:\/\/gist.github.com\/AgustOnAx\/848141d6520c89d409344cc39b39219a.js\"><\/script>\n","protected":false},"excerpt":{"rendered":"<p>Here is how to group by a field in PowerQuery and list the first value of another column:<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-38","post","type-post","status-publish","format-standard","hentry","category-power-query"],"_links":{"self":[{"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/posts\/38","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/comments?post=38"}],"version-history":[{"count":1,"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/posts\/38\/revisions"}],"predecessor-version":[{"id":39,"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/posts\/38\/revisions\/39"}],"wp:attachment":[{"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/media?parent=38"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/categories?post=38"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/coding.agust.org\/index.php\/wp-json\/wp\/v2\/tags?post=38"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}