{"id":46,"date":"2026-02-23T11:40:05","date_gmt":"2026-02-23T11:40:05","guid":{"rendered":"https:\/\/gigz.pk\/powerbi\/?post_type=lesson&#038;p=46"},"modified":"2026-03-12T05:28:42","modified_gmt":"2026-03-12T05:28:42","slug":"what-is-dax","status":"publish","type":"lesson","link":"https:\/\/gigz.pk\/powerbi\/lesson\/what-is-dax\/","title":{"rendered":"What is DAX?"},"content":{"rendered":"\n<p>DAX stands for <strong>Data Analysis Expressions<\/strong>. It is a formula language used to perform calculations, create custom metrics, and build advanced data models in tools like Microsoft Power BI, Microsoft Excel (Power Pivot), and Microsoft SQL Server Analysis Services.<\/p>\n\n\n\n<p>If Excel formulas are the foundation, DAX is the next level. It allows you to move from simple totals to powerful business intelligence logic \u2014 KPIs, growth rates, YTD calculations, ranking, segmentation, and much more.<\/p>\n\n\n\n<p>In short:<br>DAX turns raw data into decision-ready intelligence.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Why DAX is Important in Business Intelligence<\/h2>\n\n\n\n<p>Modern businesses don\u2019t just need data \u2014 they need insights.<\/p>\n\n\n\n<p>DAX helps you:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create dynamic KPIs<\/li>\n\n\n\n<li>Calculate year-over-year growth<\/li>\n\n\n\n<li>Build running totals<\/li>\n\n\n\n<li>Segment customers<\/li>\n\n\n\n<li>Rank products by performance<\/li>\n\n\n\n<li>Perform time intelligence analysis<\/li>\n<\/ul>\n\n\n\n<p>Without DAX, dashboards are static. With DAX, they become smart and interactive.<\/p>\n\n\n\n<p>If you\u2019re building reports in Power BI, learning DAX is not optional. It\u2019s essential.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Where is DAX Used?<\/h2>\n\n\n\n<p>DAX is mainly used in:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Power BI Reports<\/li>\n\n\n\n<li>Excel Power Pivot<\/li>\n\n\n\n<li>SSAS Tabular Models<\/li>\n<\/ul>\n\n\n\n<p>Whenever you create:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Measures<\/li>\n\n\n\n<li>Calculated Columns<\/li>\n\n\n\n<li>Calculated Tables<\/li>\n<\/ul>\n\n\n\n<p>You are writing DAX.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Understanding the Core Concept: Measures vs Calculated Columns<\/h2>\n\n\n\n<p>This is where many beginners get confused.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. Calculated Column<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Created row by row.<\/li>\n\n\n\n<li>Stored in the data model.<\/li>\n\n\n\n<li>Increases file size.<\/li>\n\n\n\n<li>Example:Sales Amount = Quantity * Price<\/li>\n<\/ul>\n\n\n\n<p>Each row gets its own calculated value.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. Measure<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Calculated dynamically.<\/li>\n\n\n\n<li>Depends on filter context.<\/li>\n\n\n\n<li>Does not increase model size significantly.<\/li>\n\n\n\n<li>Example:Total Sales = SUM(Sales[Sales Amount])<\/li>\n<\/ul>\n\n\n\n<p>Measures are powerful because they respond to filters, slicers, and visuals.<\/p>\n\n\n\n<p>Rule of thumb:<br>Use measures whenever possible.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Basic Structure of a DAX Formula<\/h2>\n\n\n\n<p>A simple DAX formula looks like this:<\/p>\n\n\n\n<p>Total Revenue = SUM(Sales[Revenue])<\/p>\n\n\n\n<p>Structure:<\/p>\n\n\n\n<p>Measure Name = Function(Table[Column])<\/p>\n\n\n\n<p>DAX formulas are similar to Excel, but they operate on entire columns and tables \u2014 not just individual cells.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Common DAX Functions<\/h2>\n\n\n\n<p>Here are some commonly used DAX functions:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Aggregation Functions<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SUM<\/li>\n\n\n\n<li>AVERAGE<\/li>\n\n\n\n<li>COUNT<\/li>\n\n\n\n<li>DISTINCTCOUNT<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Logical Functions<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>IF<\/li>\n\n\n\n<li>SWITCH<\/li>\n\n\n\n<li>AND<\/li>\n\n\n\n<li>OR<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Time Intelligence Functions<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>TOTALYTD<\/li>\n\n\n\n<li>SAMEPERIODLASTYEAR<\/li>\n\n\n\n<li>DATEADD<\/li>\n\n\n\n<li>DATESMTD<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Filter Functions<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>CALCULATE<\/li>\n\n\n\n<li>FILTER<\/li>\n\n\n\n<li>ALL<\/li>\n<\/ul>\n\n\n\n<p>If there is one function you must master, it is CALCULATE.<br>CALCULATE changes filter context \u2014 and filter context is everything in DAX.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What is Filter Context?<\/h2>\n\n\n\n<p>Filter context defines what data is being calculated.<\/p>\n\n\n\n<p>For example:<\/p>\n\n\n\n<p>If you select Year = 2025 in a slicer, your measure recalculates only for 2025.<\/p>\n\n\n\n<p>DAX evaluates formulas based on the current filter context created by:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Visuals<\/li>\n\n\n\n<li>Slicers<\/li>\n\n\n\n<li>Page filters<\/li>\n\n\n\n<li>Report filters<\/li>\n<\/ul>\n\n\n\n<p>Understanding filter context separates average users from professionals.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Example: Simple Business Case<\/h2>\n\n\n\n<p>Suppose you want to calculate Profit Margin.<\/p>\n\n\n\n<p>Step 1: Create a measure for Total Sales<br>Step 2: Create a measure for Total Cost<br>Step 3: Create Profit Margin<\/p>\n\n\n\n<p>Profit Margin = DIVIDE([Total Sales] &#8211; [Total Cost], [Total Sales])<\/p>\n\n\n\n<p>Now your dashboard dynamically updates margin by:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Product<\/li>\n\n\n\n<li>Region<\/li>\n\n\n\n<li>Month<\/li>\n\n\n\n<li>Sales Representative<\/li>\n<\/ul>\n\n\n\n<p>That\u2019s the power of DAX.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">DAX vs Excel Formulas<\/h2>\n\n\n\n<p>At first glance, DAX looks like Excel formulas. But the logic is different.<\/p>\n\n\n\n<p>Excel works cell by cell.<br>DAX works on data models and relationships.<\/p>\n\n\n\n<p>Excel is row-based thinking.<br>DAX is filter-context thinking.<\/p>\n\n\n\n<p>If you already know Excel, learning DAX becomes much easier \u2014 but you must shift your mindset.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">When Should You Learn DAX?<\/h2>\n\n\n\n<p>You should learn DAX if:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You build Power BI dashboards<\/li>\n\n\n\n<li>You want to become a Data Analyst<\/li>\n\n\n\n<li>You work with financial reporting<\/li>\n\n\n\n<li>You create KPIs for management<\/li>\n\n\n\n<li>You want to move from reporting to analytics<\/li>\n<\/ul>\n\n\n\n<p>In today\u2019s data-driven world, DAX is a high-demand skill.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Final ThoughtsDAX is not just a formula language. It is the engine behind intelligent dashboards.<\/h2>\n\n\n\n<p>Mastering DAX means:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Thinking in data models<\/li>\n\n\n\n<li>Understanding relationships<\/li>\n\n\n\n<li>Controlling filter context<\/li>\n\n\n\n<li>Building scalable analytics<\/li>\n<\/ul>\n\n\n\n<p>Start simple.<br>Focus on measures.<br>Understand CALCULATE deeply.<\/p>\n\n\n\n<p>Once that clicks, you stop building reports \u2014 and start building real business intelligence.<\/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\">What is DAX?<\/span><\/span><\/div>\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1773293349614\"><strong class=\"schema-faq-question\"><\/strong> <p class=\"schema-faq-answer\"><\/p> <\/div> <\/div>\n\n\n\n<p><\/p>\n","protected":false},"menu_order":0,"template":"","class_list":["post-46","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>What is DAX? - Power BI Learning Hub<\/title>\n<meta name=\"description\" content=\"Learn DAX in Power BI to create measures, KPIs, and advanced calculations for dynamic dashboards and smarter business insights.\" \/>\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=\"What is DAX? - Power BI Learning Hub\" \/>\n<meta property=\"og:description\" content=\"Learn DAX in Power BI to create measures, KPIs, and advanced calculations for dynamic dashboards and smarter business insights.\" \/>\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-12T05:28:42+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=\"3 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\\\/what-is-dax\\\/\",\"url\":\"https:\\\/\\\/gigz.pk\\\/\",\"name\":\"What is DAX? - Power BI Learning Hub\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/gigz.pk\\\/powerbi\\\/#website\"},\"datePublished\":\"2026-02-23T11:40:05+00:00\",\"dateModified\":\"2026-03-12T05:28:42+00:00\",\"description\":\"Learn DAX in Power BI to create measures, KPIs, and advanced calculations for dynamic dashboards and smarter business insights.\",\"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\":\"What is DAX?\"}]},{\"@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":"What is DAX? - Power BI Learning Hub","description":"Learn DAX in Power BI to create measures, KPIs, and advanced calculations for dynamic dashboards and smarter business insights.","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":"What is DAX? - Power BI Learning Hub","og_description":"Learn DAX in Power BI to create measures, KPIs, and advanced calculations for dynamic dashboards and smarter business insights.","og_url":"https:\/\/gigz.pk\/","og_site_name":"Power BI Learning Hub","article_modified_time":"2026-03-12T05:28:42+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["WebPage","FAQPage"],"@id":"https:\/\/gigz.pk\/powerbi\/lesson\/what-is-dax\/","url":"https:\/\/gigz.pk\/","name":"What is DAX? - Power BI Learning Hub","isPartOf":{"@id":"https:\/\/gigz.pk\/powerbi\/#website"},"datePublished":"2026-02-23T11:40:05+00:00","dateModified":"2026-03-12T05:28:42+00:00","description":"Learn DAX in Power BI to create measures, KPIs, and advanced calculations for dynamic dashboards and smarter business insights.","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":"What is DAX?"}]},{"@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\/46","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=46"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}