{"id":8482,"date":"2023-04-29T02:47:54","date_gmt":"2023-04-29T02:47:54","guid":{"rendered":"https:\/\/monocroft.com\/?p=8482"},"modified":"2023-04-29T02:47:55","modified_gmt":"2023-04-29T02:47:55","slug":"dax-101-how-to-create-a-calculated-index-column-in-power-bi","status":"publish","type":"post","link":"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/","title":{"rendered":"DAX 101: How to Create a Calculated Index Column in Power BI"},"content":{"rendered":"\n<p>In Power BI, one common use of DAX is to create a calculated index column, which assigns a unique index number to each row in a table. <\/p>\n\n\n\n<p>This index column can help with sorting, filtering, visualizing, and other functions that require a unique identifier for each row in your data.<\/p>\n\n\n\n<p>In this article, I will walk you through how to use DAX to create a calculated index column in Power BI.<\/p>\n\n\n\n<p>Let&#8217;s get started.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Understanding Calculated Columns and Index Columns<\/h2>\n\n\n\n<p>As a Power BI user, <a href=\"https:\/\/learn.microsoft.com\/en-us\/power-bi\/transform-model\/desktop-tutorial-create-calculated-columns\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">calculated columns<\/a> and <a href=\"https:\/\/learn.microsoft.com\/en-us\/power-query\/add-index-column\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">index columns<\/a> are two important concepts you must be familiar with.<\/p>\n\n\n\n<p>To start with, calculated columns are columns created in a table by defining a DAX formula that references other columns in the same or other tables. These calculated columns can calculate data or create new columns that aggregate or transform data.<\/p>\n\n\n\n<p>Index columns, on the other hand, are columns created to provide a unique identifier for each row in a table. This is often useful when you want to join tables or perform other functions that require a unique identifier for each row.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Creating a Calculated Index Column in Power BI<\/h2>\n\n\n\n<p>Now, to create a calculated index column in Power BI, you can use a combination of DAX formulas and other functions such as<code> <strong>ROW<\/strong>,<b> RANKX<\/b>, <strong>COUNTROWS and <\/strong><\/code><strong><code>FILTER<\/code><\/strong>, etc.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Using the ROW Function<\/h2>\n\n\n\n<p>In Power BI, you can use the ROW function to create a calculated index column. To do that, open Power BI Desktop and create a new table or open an existing one.<\/p>\n\n\n\n<p>Then click on &#8220;New Column&#8221; in the &#8220;Modeling&#8221; tab, and type the following DAX formula:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong><code>Index_Column = ROW()\r<\/code><\/strong><\/pre>\n\n\n\n<p>This formula uses the <strong><code>ROW <\/code><\/strong>function to return the row number of each row in the table, which serves as a unique identifier for each row.<\/p>\n\n\n\n<p>Below is another example that uses the <code><strong>ROW <\/strong><\/code>function to create a calculated index column that restarts at 1 for each category:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code><strong>Index_Column = IF(Table[Category] = EARLIER(Table[Category]), EARLIER ([Index Column]) + 1, 1)\r<\/strong><\/code><\/pre>\n\n\n\n<p>This formula uses the <code><strong>EARLIER <\/strong><\/code>function to compare the current row&#8217;s category with the one before. And if they are the same, the formula will add 1 to the previous row&#8217;s index value, but if not, the formula starts the index value at 1.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Using the RANKX Function<\/h2>\n\n\n\n<p>Another way to create a calculated index column in <code><strong>DAX <\/strong><\/code>is through the <code><strong>RANKX <\/strong><\/code>function. This function returns the rank of a value within a table, based on a specified expression.<\/p>\n\n\n\n<p>Here&#8217;s an example:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong><code>Index_Column = RANKX(ALL(Table[Column]), Table[Column])<\/code><\/strong><\/pre>\n\n\n\n<p>In this formula, the <strong><code>RANKX <\/code><\/strong>function ranks each row based on the values in the specified column <code><strong>\"[Column]\"<\/strong><\/code>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Using the COUNTROWS and FILTER Functions<\/h2>\n\n\n\n<p>Also, you can use the <code><strong>COUNTROWS <\/strong><\/code>and <code><strong>FILTER <\/strong><\/code>functions together to create a calculated index column that counts the number of rows that meet a certain condition. Below is an example:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong><code>Index_Column = COUNTROWS(FILTER(Table, Table[Column] &lt;= EARLIER (Table[Column])))<\/code><\/strong><\/pre>\n\n\n\n<p>In this example, the <code><strong>FILTER <\/strong><\/code>function filters the table to include only rows where the value in the specified column is less than or equal to the value in the previous row&#8217;s column. <\/p>\n\n\n\n<p>The <code><strong>COUNTROWS <\/strong><\/code>function then counts the number of rows that meet this condition, which serves as the calculated index value.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Using the CONCATENATE and ROW Functions<\/h2>\n\n\n\n<p>Finally, you can use the <code><strong>CONCATENATE <\/strong><\/code>and <strong><code>ROW <\/code><\/strong>together to create calculated index columns that combine the row number and the values in one or more columns. <\/p>\n\n\n\n<p>Here&#8217;s an example:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong><code>Index_Column = CONCATENATE(\"Row \", ROW(), \": \", Table[Column])\r<\/code><\/strong><\/pre>\n\n\n\n<p>The <code><strong>CONCATENATE <\/strong><\/code>function combines the string &#8220;Row &#8221; with the current row number (which is returned by the ROW function) and the value in the specified column. <\/p>\n\n\n\n<p>This creates a calculated index column that includes both the row number and the column value.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">FAQs<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">What is a calculated index column?<\/h3>\n\n\n\n<p>A calculated index column is a column in a table that ranks each row based on the values in a specific column.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Can you use a calculated index column in a visualization?<\/h3>\n\n\n\n<p>Yes, you can use a calculated index column in visualizations to show the rank of each row based on the values in a specific column.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">What are common use cases for a calculated index column?<\/h3>\n\n\n\n<p>A calculated index column can be useful for data ranking, identifying trends, creating Top N reports, etc.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">What other functions can you use with a calculated index column?<\/h3>\n\n\n\n<p>You can use a combination of other DAX functions with a calculated index column, such as FILTER, CALCULATE, SWITCH, etc.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Can you edit or remove a calculated index column in Power BI?<\/h3>\n\n\n\n<p>To edit or remove a calculated index column in Power BI, just go to the modeling tab, and right-click on the column, then select &#8220;Edit&#8221; or &#8220;Delete&#8221; from the context menu.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>Creating a calculated index column in DAX using Power BI is like a piece of cake.<\/p>\n\n\n\n<p>By following these simple steps, you can create this calculated index column and rank your data like a pro, and take your analysis to the next level.<\/p>\n\n\n\n<p>So, don&#8217;t hesitate to dive into Power BI and unleash the power of your data!<\/p>\n\n\n\n<p>If you enjoyed reading this article, you can also read <a href=\"https:\/\/monocroft.com\/how-to-calculate-rank-and-max-values-in-power-bi\/\" target=\"_blank\" rel=\"noreferrer noopener\">how to calculate RANK and MAX values in Power BI<\/a>.<\/p>\n\n\n\n<p>Thanks for reading!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Power BI, one common use of DAX is to create a calculated index column, which assigns a unique index &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"DAX 101: How to Create a Calculated Index Column in Power BI\" class=\"read-more button\" href=\"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/#more-8482\" aria-label=\"More on DAX 101: How to Create a Calculated Index Column in Power BI\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":8486,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,8],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>DAX 101: How to Create a Calculated Index Column in Power BI - Monocroft<\/title>\n<meta name=\"description\" content=\"Need to create an index column in DAX? Look no further than this comprehensive guide, complete with screenshots and examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DAX 101: How to Create a Calculated Index Column in Power BI - Monocroft\" \/>\n<meta property=\"og:description\" content=\"Need to create an index column in DAX? Look no further than this comprehensive guide, complete with screenshots and examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"Monocroft\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-29T02:47:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-29T02:47:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/04\/create-index-column-in-dax-monocroft.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"720\" \/>\n\t<meta property=\"og:image:height\" content=\"405\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Matt\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Matt\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/\"},\"author\":{\"name\":\"Matt\",\"@id\":\"https:\/\/monocroft.com\/#\/schema\/person\/3aeab97c9b5661d211c0742c48f024b3\"},\"headline\":\"DAX 101: How to Create a Calculated Index Column in Power BI\",\"datePublished\":\"2023-04-29T02:47:54+00:00\",\"dateModified\":\"2023-04-29T02:47:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/\"},\"wordCount\":829,\"publisher\":{\"@id\":\"https:\/\/monocroft.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/04\/create-index-column-in-dax-monocroft.jpg\",\"articleSection\":[\"Guides\",\"PowerBI\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/\",\"url\":\"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/\",\"name\":\"DAX 101: How to Create a Calculated Index Column in Power BI - Monocroft\",\"isPartOf\":{\"@id\":\"https:\/\/monocroft.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/04\/create-index-column-in-dax-monocroft.jpg\",\"datePublished\":\"2023-04-29T02:47:54+00:00\",\"dateModified\":\"2023-04-29T02:47:55+00:00\",\"description\":\"Need to create an index column in DAX? Look no further than this comprehensive guide, complete with screenshots and examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/#primaryimage\",\"url\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/04\/create-index-column-in-dax-monocroft.jpg\",\"contentUrl\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/04\/create-index-column-in-dax-monocroft.jpg\",\"width\":720,\"height\":405,\"caption\":\"create index column in dax - monocroft\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/monocroft.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DAX 101: How to Create a Calculated Index Column in Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/monocroft.com\/#website\",\"url\":\"https:\/\/monocroft.com\/\",\"name\":\"Monocroft\",\"description\":\"Monocroft Tech\",\"publisher\":{\"@id\":\"https:\/\/monocroft.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/monocroft.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/monocroft.com\/#organization\",\"name\":\"Triburge\",\"url\":\"https:\/\/monocroft.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/monocroft.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/07\/monocroft-logo.png\",\"contentUrl\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/07\/monocroft-logo.png\",\"width\":512,\"height\":512,\"caption\":\"Triburge\"},\"image\":{\"@id\":\"https:\/\/monocroft.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/monocroft.com\/#\/schema\/person\/3aeab97c9b5661d211c0742c48f024b3\",\"name\":\"Matt\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/monocroft.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c06bcee4d38a649222493c5e9f11f7a5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c06bcee4d38a649222493c5e9f11f7a5?s=96&d=mm&r=g\",\"caption\":\"Matt\"},\"url\":\"https:\/\/monocroft.com\/author\/matthew\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DAX 101: How to Create a Calculated Index Column in Power BI - Monocroft","description":"Need to create an index column in DAX? Look no further than this comprehensive guide, complete with screenshots and examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"DAX 101: How to Create a Calculated Index Column in Power BI - Monocroft","og_description":"Need to create an index column in DAX? Look no further than this comprehensive guide, complete with screenshots and examples.","og_url":"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/","og_site_name":"Monocroft","article_published_time":"2023-04-29T02:47:54+00:00","article_modified_time":"2023-04-29T02:47:55+00:00","og_image":[{"width":720,"height":405,"url":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/04\/create-index-column-in-dax-monocroft.jpg","type":"image\/jpeg"}],"author":"Matt","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Matt","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/#article","isPartOf":{"@id":"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/"},"author":{"name":"Matt","@id":"https:\/\/monocroft.com\/#\/schema\/person\/3aeab97c9b5661d211c0742c48f024b3"},"headline":"DAX 101: How to Create a Calculated Index Column in Power BI","datePublished":"2023-04-29T02:47:54+00:00","dateModified":"2023-04-29T02:47:55+00:00","mainEntityOfPage":{"@id":"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/"},"wordCount":829,"publisher":{"@id":"https:\/\/monocroft.com\/#organization"},"image":{"@id":"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/04\/create-index-column-in-dax-monocroft.jpg","articleSection":["Guides","PowerBI"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/","url":"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/","name":"DAX 101: How to Create a Calculated Index Column in Power BI - Monocroft","isPartOf":{"@id":"https:\/\/monocroft.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/04\/create-index-column-in-dax-monocroft.jpg","datePublished":"2023-04-29T02:47:54+00:00","dateModified":"2023-04-29T02:47:55+00:00","description":"Need to create an index column in DAX? Look no further than this comprehensive guide, complete with screenshots and examples.","breadcrumb":{"@id":"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/#primaryimage","url":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/04\/create-index-column-in-dax-monocroft.jpg","contentUrl":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/04\/create-index-column-in-dax-monocroft.jpg","width":720,"height":405,"caption":"create index column in dax - monocroft"},{"@type":"BreadcrumbList","@id":"https:\/\/monocroft.com\/dax-101-how-to-create-a-calculated-index-column-in-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/monocroft.com\/"},{"@type":"ListItem","position":2,"name":"DAX 101: How to Create a Calculated Index Column in Power BI"}]},{"@type":"WebSite","@id":"https:\/\/monocroft.com\/#website","url":"https:\/\/monocroft.com\/","name":"Monocroft","description":"Monocroft Tech","publisher":{"@id":"https:\/\/monocroft.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/monocroft.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/monocroft.com\/#organization","name":"Triburge","url":"https:\/\/monocroft.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/monocroft.com\/#\/schema\/logo\/image\/","url":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/07\/monocroft-logo.png","contentUrl":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/07\/monocroft-logo.png","width":512,"height":512,"caption":"Triburge"},"image":{"@id":"https:\/\/monocroft.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/monocroft.com\/#\/schema\/person\/3aeab97c9b5661d211c0742c48f024b3","name":"Matt","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/monocroft.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c06bcee4d38a649222493c5e9f11f7a5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c06bcee4d38a649222493c5e9f11f7a5?s=96&d=mm&r=g","caption":"Matt"},"url":"https:\/\/monocroft.com\/author\/matthew\/"}]}},"_links":{"self":[{"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/posts\/8482"}],"collection":[{"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/comments?post=8482"}],"version-history":[{"count":120,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/posts\/8482\/revisions"}],"predecessor-version":[{"id":8604,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/posts\/8482\/revisions\/8604"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/media\/8486"}],"wp:attachment":[{"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/media?parent=8482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/categories?post=8482"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/tags?post=8482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}