{"id":1772,"date":"2020-10-02T10:21:31","date_gmt":"2020-10-02T10:21:31","guid":{"rendered":"https:\/\/bi.unija.com\/en\/?p=1772"},"modified":"2020-10-22T11:48:02","modified_gmt":"2020-10-22T11:48:02","slug":"dax-functions","status":"publish","type":"post","link":"https:\/\/bi.unija.com\/en\/dax-functions\/","title":{"rendered":"DAX functions"},"content":{"rendered":"

For Power BI version 2.76.5678.782 (December 2019).<\/em><\/p>\n

Let’s look at the most common functions we use when working with DAX. All functions in this article (except for the function DIVIDE) are aggregator functions. This means they take a column (or table) as input and aggregate the values into a single result.<\/p>\n

SUM()<\/h1>\n

Returns the sum of all the values in a column.<\/p>\n

Syntax<\/h2>\n

SUM([Column])<\/p>\n\n\n\n\n
Parameter<\/td>\nDescription<\/td>\n<\/tr>\n
Column<\/td>\nColumn to be aggregated.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Example<\/h2>\n

SUM_Example = SUM(Sales[Amount])<\/p>\n

Example calculates the sum of Amount column in the Sales table.<\/p>\n

AVERAGE()<\/h1>\n

Returns the average of all the values in a column.<\/p>\n

Syntax<\/h2>\n

AVERAGE([Column])<\/p>\n\n\n\n\n
Parameter<\/td>\nDescription<\/td>\n<\/tr>\n
Column<\/td>\nColumn to be aggregated.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Example<\/h2>\n

AVERAGE_Example = AVERAGE(Sales[Amount])<\/p>\n

Example calculates the average of Amount column in the Sales table.<\/p>\n

MIN()<\/h1>\n

Returns the lowest of all the values in a column.<\/p>\n

Syntax<\/h2>\n

MIN([Column])<\/p>\n\n\n\n\n
Parameter<\/td>\nDescription<\/td>\n<\/tr>\n
Column<\/td>\nColumn of values.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Example<\/h2>\n

MIN_Example = MIN(Sales[Amount])<\/p>\n

Example returns the lowest value of Amount column in the Sales table.<\/p>\n

MAX()<\/h1>\n

Returns the highest of all the values in a column.<\/p>\n

Syntax<\/h2>\n

MAX([Column])<\/p>\n\n\n\n\n
Parameter<\/td>\nDescription<\/td>\n<\/tr>\n
Column<\/td>\nColumn of values.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Example<\/h2>\n

MAX_Example = MAX(Sales[Amount])<\/p>\n

Example returns the highest value of Amount column in the Sales table.<\/p>\n

COUNT()<\/h1>\n

Returns the number of non-empty values in a column.<\/p>\n

Syntax<\/h2>\n

COUNT([Column])<\/p>\n\n\n\n\n
Parameter<\/td>\nDescription<\/td>\n<\/tr>\n
Column<\/td>\nColumn of values.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Example<\/h2>\n

COUNT_Example = COUNT(Sales[Amount])<\/p>\n

Example returns the number of non-empty values of Amount column in the Sales table.<\/p>\n

COUNTBLANK()<\/h1>\n

Returns the number of empty values in a column.<\/p>\n

Syntax<\/h2>\n

COUNTBLANK([Column])<\/p>\n\n\n\n\n
Parameter<\/td>\nDescription<\/td>\n<\/tr>\n
Column<\/td>\nColumn of values.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Example<\/h2>\n

COUNTBLANK_Example = COUNTBLANK(Sales[Amount])<\/p>\n

Example returns the number of empty values of Amount column in the Sales table.<\/p>\n

COUNTROWS()<\/h1>\n

Returns the number of rows in a table.<\/p>\n

Syntax<\/h2>\n

COUNTROWS(Table)<\/p>\n\n\n\n\n
Parameter<\/td>\nDescription<\/td>\n<\/tr>\n
Table<\/td>\nTable we want to count rows in.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Example<\/h2>\n

COUNTROWS_Example = COUNTROWS(‘Sales’)<\/p>\n

Example returns the number of rows the Sales table.<\/p>\n

DIVIDE()<\/h1>\n

Divides and returns the result. Returns BLANK in the case of dividing by 0.<\/p>\n

Syntax<\/h2>\n

DIVIDE(Numerator, Denominator, [Alternative result])<\/p>\n\n\n\n\n\n\n
Parameter<\/td>\nDescription<\/td>\n<\/tr>\n
Numerator<\/td>\nNumerator<\/td>\n<\/tr>\n
Denominator<\/td>\nDenominator<\/td>\n<\/tr>\n
Alternative result<\/td>\nAlternative result in case of errors or dividing by 0. If no alternative result is given, BLANK is used. (optional)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Example<\/h2>\n

DIVIDE_Example = DIVIDE(10, 2)<\/p>\n

Example divides 10 by 2 and returns 5.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

For Power BI version 2.76.5678.782 (December 2019). Let’s look at the most common functions we use when working with DAX. All functions in this article (except for the function DIVIDE) are aggregator functions. This means they take a column (or<\/p>\n","protected":false},"author":5,"featured_media":1773,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[3],"tags":[5,8],"class_list":["post-1772","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-intermediate","tag-dax","tag-power-bi"],"acf":[],"yoast_head":"\nDAX functions - Bi Unija<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bi.unija.com\/en\/dax-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DAX functions - Bi Unija\" \/>\n<meta property=\"og:description\" content=\"For Power BI version 2.76.5678.782 (December 2019). Let’s look at the most common functions we use when working with DAX. All functions in this article (except for the function DIVIDE) are aggregator functions. This means they take a column (or\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bi.unija.com\/en\/dax-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"Bi Unija\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-02T10:21:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-22T11:48:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/10\/27eng.png\" \/>\n\t<meta property=\"og:image:width\" content=\"720\" \/>\n\t<meta property=\"og:image:height\" content=\"480\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Branka Trifunovi\u0107\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Branka Trifunovi\u0107\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/bi.unija.com\/en\/dax-functions\/\",\"url\":\"https:\/\/bi.unija.com\/en\/dax-functions\/\",\"name\":\"DAX functions - Bi Unija\",\"isPartOf\":{\"@id\":\"https:\/\/bi.unija.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/bi.unija.com\/en\/dax-functions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/bi.unija.com\/en\/dax-functions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/10\/27eng.png\",\"datePublished\":\"2020-10-02T10:21:31+00:00\",\"dateModified\":\"2020-10-22T11:48:02+00:00\",\"author\":{\"@id\":\"https:\/\/bi.unija.com\/en\/#\/schema\/person\/3bed36623727c7162e421c4366a54e10\"},\"breadcrumb\":{\"@id\":\"https:\/\/bi.unija.com\/en\/dax-functions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/bi.unija.com\/en\/dax-functions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/bi.unija.com\/en\/dax-functions\/#primaryimage\",\"url\":\"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/10\/27eng.png\",\"contentUrl\":\"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/10\/27eng.png\",\"width\":720,\"height\":480},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/bi.unija.com\/en\/dax-functions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/bi.unija.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DAX functions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/bi.unija.com\/en\/#website\",\"url\":\"https:\/\/bi.unija.com\/en\/\",\"name\":\"Bi Unija\",\"description\":\"Just another Bi site\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/bi.unija.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/bi.unija.com\/en\/#\/schema\/person\/3bed36623727c7162e421c4366a54e10\",\"name\":\"Branka Trifunovi\u0107\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/bi.unija.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ec99f651bcc98a163161515ec254b974?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ec99f651bcc98a163161515ec254b974?s=96&d=mm&r=g\",\"caption\":\"Branka Trifunovi\u0107\"},\"url\":\"https:\/\/bi.unija.com\/en\/author\/branka\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DAX functions - Bi Unija","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:\/\/bi.unija.com\/en\/dax-functions\/","og_locale":"en_US","og_type":"article","og_title":"DAX functions - Bi Unija","og_description":"For Power BI version 2.76.5678.782 (December 2019). Let’s look at the most common functions we use when working with DAX. All functions in this article (except for the function DIVIDE) are aggregator functions. This means they take a column (or","og_url":"https:\/\/bi.unija.com\/en\/dax-functions\/","og_site_name":"Bi Unija","article_published_time":"2020-10-02T10:21:31+00:00","article_modified_time":"2020-10-22T11:48:02+00:00","og_image":[{"width":720,"height":480,"url":"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/10\/27eng.png","type":"image\/png"}],"author":"Branka Trifunovi\u0107","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Branka Trifunovi\u0107","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/bi.unija.com\/en\/dax-functions\/","url":"https:\/\/bi.unija.com\/en\/dax-functions\/","name":"DAX functions - Bi Unija","isPartOf":{"@id":"https:\/\/bi.unija.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bi.unija.com\/en\/dax-functions\/#primaryimage"},"image":{"@id":"https:\/\/bi.unija.com\/en\/dax-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/10\/27eng.png","datePublished":"2020-10-02T10:21:31+00:00","dateModified":"2020-10-22T11:48:02+00:00","author":{"@id":"https:\/\/bi.unija.com\/en\/#\/schema\/person\/3bed36623727c7162e421c4366a54e10"},"breadcrumb":{"@id":"https:\/\/bi.unija.com\/en\/dax-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bi.unija.com\/en\/dax-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bi.unija.com\/en\/dax-functions\/#primaryimage","url":"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/10\/27eng.png","contentUrl":"https:\/\/bi.unija.com\/en\/wp-content\/uploads\/sites\/2\/2020\/10\/27eng.png","width":720,"height":480},{"@type":"BreadcrumbList","@id":"https:\/\/bi.unija.com\/en\/dax-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bi.unija.com\/en\/"},{"@type":"ListItem","position":2,"name":"DAX functions"}]},{"@type":"WebSite","@id":"https:\/\/bi.unija.com\/en\/#website","url":"https:\/\/bi.unija.com\/en\/","name":"Bi Unija","description":"Just another Bi site","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bi.unija.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/bi.unija.com\/en\/#\/schema\/person\/3bed36623727c7162e421c4366a54e10","name":"Branka Trifunovi\u0107","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bi.unija.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ec99f651bcc98a163161515ec254b974?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ec99f651bcc98a163161515ec254b974?s=96&d=mm&r=g","caption":"Branka Trifunovi\u0107"},"url":"https:\/\/bi.unija.com\/en\/author\/branka\/"}]}},"_links":{"self":[{"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/posts\/1772"}],"collection":[{"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/comments?post=1772"}],"version-history":[{"count":1,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/posts\/1772\/revisions"}],"predecessor-version":[{"id":1774,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/posts\/1772\/revisions\/1774"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/media\/1773"}],"wp:attachment":[{"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/media?parent=1772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/categories?post=1772"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bi.unija.com\/en\/wp-json\/wp\/v2\/tags?post=1772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}