{"id":16251,"date":"2021-05-01T15:14:25","date_gmt":"2021-05-01T09:44:25","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=16251"},"modified":"2021-05-01T15:14:25","modified_gmt":"2021-05-01T09:44:25","slug":"data-analysis-expression","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/","title":{"rendered":"What is DAX In Power BI?"},"content":{"rendered":"<p>Data Analysis Expressions (DAX) is a syntax language that comprises formulae and expressions that are used in data manipulation. Functions, constants, and operators are used in DAX to create expressions.<\/p>\n<p>How does it work?<\/p>\n<p>DAX works on a combination of three fundamental concepts:<\/p>\n<p>\u27a5 Syntax Syntax refers to the components of the formula you are making. It is the language used in the formula like the command, sign, operators, destination column or row or table, etc. For example, name, parenthesis, summation, name of the table, etc.<\/p>\n<p>\u27a5 Context Context refers to the target row that has been included in the formula for data retrieval or calculation. Context is present in two types: Row Context and Filter Context.<\/p>\n<p>\u27a5 Functions Functions refer to the predefined or already existing commands in the system. For example, Sum, Add, True, False, etc.<\/p>\n<p>Some of the major advantages of Power BI are:<\/p>\n<p>\u27a5 Real-time data visualization<\/p>\n<p>\u27a5 Creation of charts and report generation on voice command using Cortana<\/p>\n<p>\u27a5 Large storage space and easy retrieval of data from the storage<\/p>\n<p>\u27a5 Higher security at the Row level Sounds Interesting? For more information, read this blog <a class=\"waffle-rich-text-link\" href=\"https:\/\/k21academy.com\/microsoft-azure\/da-100\/data-analysis-expression\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=da10015_may21\" target=\"_blank\" rel=\"noopener noreferrer\"><em>k21academy.com\/da1001<\/em>5<\/a><\/p>\n<p>If you are planning to become a Microsoft Data Analyst Certification, then join the FREE CLASS now at <a href=\"https:\/\/k21academy.com\/da100-microsoft-data-analyst-free-class\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=da10002_may21\" target=\"_blank\" rel=\"noopener noreferrer\"><em>k21academy.com\/da10002<\/em><\/a>.<\/p>\n<p><a href=\"https:\/\/k21academy.com\/da100-microsoft-data-analyst-free-class\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=da10002_may21\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/k21academy.com\/wp-content\/uploads\/2021\/04\/DA104_FC2_CU.gif\" alt=\"\" width=\"1277\" height=\"191\" \/><\/a><\/p>\n<p>Also, do not forget to join us on our FREE Telegram group<em> <a href=\"https:\/\/t.me\/k21microsoftazure\">t.me\/k21microsoftazure<\/a><\/em> , and be the first to receive Microsoft Azure-related news and updates.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data Analysis Expressions (DAX) is a syntax language that comprises formulae and expressions that are used in data manipulation. Functions, [&hellip;]<\/p>\n","protected":false},"author":115,"featured_media":16256,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[564,540,1],"tags":[],"class_list":["post-16251","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-analyst","category-microsoft-azure","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Data Analysis Expressions (DAX) In Power BI | K21 Academy<\/title>\n<meta name=\"description\" content=\"This blog provides only a basic introduction to the Data Analysis Expression (DAX). It describes DAX as it applies to all the products that use it.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Analysis Expressions (DAX) In Power BI | K21 Academy\" \/>\n<meta property=\"og:description\" content=\"This blog provides only a basic introduction to the Data Analysis Expression (DAX). It describes DAX as it applies to all the products that use it.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-01T09:44:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/05\/DAX.Functions_BlogImage-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1125\" \/>\n\t<meta property=\"og:image:height\" content=\"629\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/\",\"name\":\"Data Analysis Expressions (DAX) In Power BI | K21 Academy\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/05\/DAX.Functions_BlogImage-1.png\",\"datePublished\":\"2021-05-01T09:44:25+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"description\":\"This blog provides only a basic introduction to the Data Analysis Expression (DAX). It describes DAX as it applies to all the products that use it.\",\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/#primaryimage\",\"url\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/05\/DAX.Functions_BlogImage-1.png\",\"contentUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/05\/DAX.Functions_BlogImage-1.png\",\"width\":1125,\"height\":629,\"caption\":\"DAX Functions\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is DAX In Power BI?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation &amp; Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Analysis Expressions (DAX) In Power BI | K21 Academy","description":"This blog provides only a basic introduction to the Data Analysis Expression (DAX). It describes DAX as it applies to all the products that use it.","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:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/","og_locale":"en_US","og_type":"article","og_title":"Data Analysis Expressions (DAX) In Power BI | K21 Academy","og_description":"This blog provides only a basic introduction to the Data Analysis Expression (DAX). It describes DAX as it applies to all the products that use it.","og_url":"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/","article_published_time":"2021-05-01T09:44:25+00:00","og_image":[{"width":1125,"height":629,"url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/05\/DAX.Functions_BlogImage-1.png","type":"image\/png"}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/","url":"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/","name":"Data Analysis Expressions (DAX) In Power BI | K21 Academy","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/#primaryimage"},"thumbnailUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/05\/DAX.Functions_BlogImage-1.png","datePublished":"2021-05-01T09:44:25+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"description":"This blog provides only a basic introduction to the Data Analysis Expression (DAX). It describes DAX as it applies to all the products that use it.","breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/#primaryimage","url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/05\/DAX.Functions_BlogImage-1.png","contentUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/05\/DAX.Functions_BlogImage-1.png","width":1125,"height":629,"caption":"DAX Functions"},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/data-analysis-expression\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"What is DAX In Power BI?"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation &amp; Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/16251","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=16251"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/16251\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media\/16256"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=16251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=16251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=16251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}