{"id":99,"date":"2026-02-26T07:50:44","date_gmt":"2026-02-26T07:50:44","guid":{"rendered":"https:\/\/gigz.pk\/powerbi\/?post_type=lesson&#038;p=99"},"modified":"2026-03-17T06:47:45","modified_gmt":"2026-03-17T06:47:45","slug":"year-over-year-growth","status":"publish","type":"lesson","link":"https:\/\/gigz.pk\/powerbi\/lesson\/year-over-year-growth\/","title":{"rendered":"Year-over-Year Growth"},"content":{"rendered":"\n<p>Year-over-Year (YoY) growth is used to compare a metric for the current year with the same metric in the previous year. It helps businesses track annual performance, identify trends, and measure growth over time.<\/p>\n\n\n\n<p>YoY growth is commonly applied to metrics such as sales, revenue, profit, or customer count.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Key Concept<\/h2>\n\n\n\n<p>YoY calculations require a <strong>Date Table<\/strong> marked as a Date Table in Power BI. Measures are used to calculate values for the current year and the previous year.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">DAX Example \u2013 Basic YoY Growth<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Total Sales Measure<\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\">Total Sales = SUM(Sales[Amount])<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Previous Year Sales Measure<\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\">Sales LY = CALCULATE(<br>    [Total Sales],<br>    SAMEPERIODLASTYEAR(DateTable[Date])<br>)<\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>SAMEPERIODLASTYEAR<\/strong> shifts the filter context to the same period in the previous year.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: YoY Growth Percentage<\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\">YoY Growth % = <br>DIVIDE(<br>    [Total Sales] - [Sales LY],<br>    [Sales LY],<br>    0<br>)<\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Calculates the percentage change compared to the same period last year.<\/li>\n\n\n\n<li>Returns 0 if the previous year has no data.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Visualizing YoY Growth<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use <strong>line charts<\/strong> to show trends over years.<\/li>\n\n\n\n<li>Use <strong>column or bar charts<\/strong> to compare current vs. previous year values.<\/li>\n\n\n\n<li>Use <strong>cards or KPI visuals<\/strong> to display YoY growth percentages clearly.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Best Practices<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Always use a <strong>dedicated Date Table<\/strong> with continuous dates.<\/li>\n\n\n\n<li>Mark the Date Table as a <strong>Date Table<\/strong> in Power BI to enable proper time intelligence functions.<\/li>\n\n\n\n<li>Combine YoY growth with <strong>MoM<\/strong> and <strong>YTD<\/strong> metrics for comprehensive time-based analysis.<\/li>\n\n\n\n<li>Ensure labels and titles are clear to show which year is being compared.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>Year-over-Year growth is an essential metric for tracking annual performance and understanding business trends. Using DAX functions like SAMEPERIODLASTYEAR with CALCULATE, you can create dynamic YoY measures in Power BI for interactive and insightful reports.<\/p>\n\n\n<div class=\"yoast-breadcrumbs\"><span><span><a href=\"https:\/\/gigz.pk\/powerbi\/\">Home<\/a><\/span> \u00bb <span class=\"breadcrumb_last\" aria-current=\"page\">Power BI DAX Mastery > Time Intelligence > Year-over-Year Growth<\/span><\/span><\/div>\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1773730234810\"><strong class=\"schema-faq-question\"><\/strong> <p class=\"schema-faq-answer\"><\/p> <\/div> <\/div>\n","protected":false},"menu_order":36,"template":"","class_list":["post-99","lesson","type-lesson","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Year-over-Year Growth - Power BI Learning Hub<\/title>\n<meta name=\"description\" content=\"Calculate Year-over-Year (YoY) growth in Power BI using SAMEPERIODLASTYEAR. Learn to track annual performance dynamically.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/gigz.pk\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Year-over-Year Growth - Power BI Learning Hub\" \/>\n<meta property=\"og:description\" content=\"Calculate Year-over-Year (YoY) growth in Power BI using SAMEPERIODLASTYEAR. Learn to track annual performance dynamically.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/gigz.pk\/\" \/>\n<meta property=\"og:site_name\" content=\"Power BI Learning Hub\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-17T06:47:45+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\\\/\\\/gigz.pk\\\/powerbi\\\/lesson\\\/year-over-year-growth\\\/\",\"url\":\"https:\\\/\\\/gigz.pk\\\/\",\"name\":\"Year-over-Year Growth - Power BI Learning Hub\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/gigz.pk\\\/powerbi\\\/#website\"},\"datePublished\":\"2026-02-26T07:50:44+00:00\",\"dateModified\":\"2026-03-17T06:47:45+00:00\",\"description\":\"Calculate Year-over-Year (YoY) growth in Power BI using SAMEPERIODLASTYEAR. Learn to track annual performance dynamically.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/gigz.pk\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/gigz.pk\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/gigz.pk\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/gigz.pk\\\/powerbi\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI DAX Mastery > Time Intelligence > Year-over-Year Growth\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/gigz.pk\\\/powerbi\\\/#website\",\"url\":\"https:\\\/\\\/gigz.pk\\\/powerbi\\\/\",\"name\":\"Power BI Learning Hub\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/gigz.pk\\\/powerbi\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Year-over-Year Growth - Power BI Learning Hub","description":"Calculate Year-over-Year (YoY) growth in Power BI using SAMEPERIODLASTYEAR. Learn to track annual performance dynamically.","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:\/\/gigz.pk\/","og_locale":"en_US","og_type":"article","og_title":"Year-over-Year Growth - Power BI Learning Hub","og_description":"Calculate Year-over-Year (YoY) growth in Power BI using SAMEPERIODLASTYEAR. Learn to track annual performance dynamically.","og_url":"https:\/\/gigz.pk\/","og_site_name":"Power BI Learning Hub","article_modified_time":"2026-03-17T06:47:45+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["WebPage","FAQPage"],"@id":"https:\/\/gigz.pk\/powerbi\/lesson\/year-over-year-growth\/","url":"https:\/\/gigz.pk\/","name":"Year-over-Year Growth - Power BI Learning Hub","isPartOf":{"@id":"https:\/\/gigz.pk\/powerbi\/#website"},"datePublished":"2026-02-26T07:50:44+00:00","dateModified":"2026-03-17T06:47:45+00:00","description":"Calculate Year-over-Year (YoY) growth in Power BI using SAMEPERIODLASTYEAR. Learn to track annual performance dynamically.","breadcrumb":{"@id":"https:\/\/gigz.pk\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/gigz.pk\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/gigz.pk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/gigz.pk\/powerbi\/"},{"@type":"ListItem","position":2,"name":"Power BI DAX Mastery > Time Intelligence > Year-over-Year Growth"}]},{"@type":"WebSite","@id":"https:\/\/gigz.pk\/powerbi\/#website","url":"https:\/\/gigz.pk\/powerbi\/","name":"Power BI Learning Hub","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/gigz.pk\/powerbi\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/gigz.pk\/powerbi\/wp-json\/wp\/v2\/lesson\/99","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gigz.pk\/powerbi\/wp-json\/wp\/v2\/lesson"}],"about":[{"href":"https:\/\/gigz.pk\/powerbi\/wp-json\/wp\/v2\/types\/lesson"}],"wp:attachment":[{"href":"https:\/\/gigz.pk\/powerbi\/wp-json\/wp\/v2\/media?parent=99"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}