{"id":33789,"date":"2021-01-23T13:16:39","date_gmt":"2021-01-23T13:16:39","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=33789"},"modified":"2021-01-23T13:16:41","modified_gmt":"2021-01-23T13:16:41","slug":"statistical-functions-dax","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/statistical-functions-dax\/","title":{"rendered":"Statistical Functions DAX"},"content":{"rendered":"\n

Data Analysis Expressions (DAX) facilitates with many functions used for creating aggregations including sums, counts, and averages. However, these functions are more like the aggregation functions used by Microsoft Excel. We shall now list the statistical functions used for aggregation provided in DAX.<\/p>\n\n\n\n

Function<\/th>Description<\/th><\/tr><\/thead>
APPROXIMATEDISTINCTCOUNT<\/td>It is used to return the\u00a0approximate<\/em>\u00a0number of rows that contain distinct values in a column.<\/td><\/tr>
AVERAGE<\/td>It is used to return the average (arithmetic mean) of all the numbers in a column.<\/td><\/tr>
AVERAGEA<\/td>It is used to return the average (arithmetic mean) of the values in a column.<\/td><\/tr>
AVERAGEX<\/td>It is used to calculate the average (arithmetic mean) of a set of expressions evaluated over a table.<\/td><\/tr>
BETA.DIST<\/td>It is used to return the beta distribution.<\/td><\/tr>
BETA.INV<\/td>It is used to return the inverse of the beta cumulative probability density function (BETA.DIST).<\/td><\/tr>
CHISQ.DIST<\/td>It is used to return the chi-squared distribution.<\/td><\/tr>
CHISQ.DIST.RT<\/td>It is used to return the right-tailed probability of the chi-squared distribution.<\/td><\/tr>
CHISQ.INV<\/td>It is used to return the inverse of the left-tailed probability of the chi-squared distribution.<\/td><\/tr>
CHISQ.INV.RT<\/td>It is used to return the inverse of the right-tailed probability of the chi-squared distribution.<\/td><\/tr>
CONFIDENCE.NORM<\/td>The confidence interval is a range of values.<\/td><\/tr>
CONFIDENCE.T<\/td>It is used to return the confidence interval for a population mean, using a Student’s t distribution.<\/td><\/tr>
COT<\/td>It is used to return the cotangent of an angle specified in radians.<\/td><\/tr>
COTH<\/td>It is used to return the hyperbolic cotangent of a hyperbolic angle.<\/td><\/tr>
COUNT<\/td>It is used to count the number of cells in a column that contain numbers.<\/td><\/tr>
COUNTA<\/td>It is used to count the number of cells in a column that are not empty.<\/td><\/tr>
COUNTAX<\/td>It is used to count nonblank results when evaluating the result of an expression over a table.<\/td><\/tr>
COUNTBLANK<\/td>It is used to count the number of blank cells in a column.<\/td><\/tr>
COUNTROWS<\/td>It is used to count the number of rows in the specified table, or in a table defined by an expression.<\/td><\/tr>
COUNTX<\/td>It is used to count the number of rows that contain a number or an expression that evaluates to a number, when evaluating an expression over a table.<\/td><\/tr>
DATATABLE<\/td>It provides a mechanism for declaring an inline set of data values.<\/td><\/tr>
DISTINCTCOUNT<\/td>It is used to count the number of distinct values in a column.<\/td><\/tr>
DISTINCTCOUNTNOBLANK<\/td>It is used to count the number of distinct values in a column.<\/td><\/tr>
EXPON.DIST<\/td>It is used to return the exponential distribution.<\/td><\/tr>
GEOMEAN<\/td>It is used to return the geometric mean of the numbers in a column.<\/td><\/tr>
GEOMEANX<\/td>It is used to return the geometric mean of an expression evaluated for each row in a table.<\/td><\/tr>
MAX<\/td>It is used to return the largest numeric value in a column, or between two scalar expressions.<\/td><\/tr>
MAXA<\/td>It is used to return the largest value in a column.<\/td><\/tr>
MAXX<\/td>It is used to evaluate an expression for each row of a table and returns the largest numeric value.<\/td><\/tr>
MEDIAN<\/td>It is used to return the median of numbers in a column.<\/td><\/tr>
MEDIANX<\/td>It is used to return the median number of an expression evaluated for each row in a table.<\/td><\/tr>
MIN<\/td>It is used to return the smallest numeric value in a column, or between two scalar expressions.<\/td><\/tr>
MINA<\/td>It is used to return the smallest value in a column, including any logical values and numbers represented as text.<\/td><\/tr>
MINX<\/td>It is used to return the smallest numeric value that results from evaluating an expression for each row of a table.<\/td><\/tr>
NORM.DIST<\/td>It is used to return the normal distribution for the specified mean and standard deviation.<\/td><\/tr>
NORM.INV<\/td>The inverse of the normal cumulative distribution for the specified mean and standard deviation.<\/td><\/tr>
NORM.S.DIST<\/td>It is used to return the standard normal distribution (has a mean of zero and a standard deviation of one).<\/td><\/tr>
NORM.S.INV<\/td>It is used to return the inverse of the standard normal cumulative distribution.<\/td><\/tr>
PERCENTILE.EXC<\/td>It is used to return the k-th percentile of values in a range, where k is in the range 0..1, exclusive.<\/td><\/tr>
PERCENTILE.INC<\/td>It is used to return the k-th percentile of values in a range, where k is in the range 0..1, inclusive.<\/td><\/tr>
PERCENTILEX.EXC<\/td>It is used to return the percentile number of an expression evaluated for each row in a table.<\/td><\/tr>
PERCENTILEX.INC<\/td>It is used to return the percentile number of an expression evaluated for each row in a table.<\/td><\/tr>
POISSON.DIST<\/td>It is used to return the Poisson distribution.<\/td><\/tr>
RANK.EQ<\/td>It is used to return the ranking of a number in a list of numbers.<\/td><\/tr>
RANKX<\/td>It is used to return the ranking of a number in a list of numbers for each row in the\u00a0table<\/em>\u00a0argument.<\/td><\/tr>
SAMPLE<\/td>It is used to return a sample of N rows from the specified table.<\/td><\/tr>
SIN<\/td>It is used to return the sine of the given angle.<\/td><\/tr>
SINH<\/td>It is used to return the hyperbolic sine of a number.<\/td><\/tr>
STDEV.P<\/td>It is used to return the standard deviation of the entire population.<\/td><\/tr>
STDEV.S<\/td>It is used to return the standard deviation of a sample population.<\/td><\/tr>
STDEVX.P<\/td>It is used to return the standard deviation of the entire population.<\/td><\/tr>
STDEVX.S<\/td>It is used to return the standard deviation of a sample population.<\/td><\/tr>
SQRTPI<\/td>It is used to return the square root of (number * pi).<\/td><\/tr>
T.DIST<\/td>It is used to return the Student’s left-tailed t-distribution.<\/td><\/tr>
T.DIST.2T<\/td>It is used to return the two-tailed Student’s t-distribution.<\/td><\/tr>
T.DIST.RT<\/td>It is used to return the right-tailed Student’s t-distribution.<\/td><\/tr>
T.INV<\/td>It is used to return the left-tailed inverse of the Student’s t-distribution.<\/td><\/tr>
T.INV.2t<\/td>It is used to return the two-tailed inverse of the Student’s t-distribution.<\/td><\/tr>
TAN<\/td>It is used to return the tangent of the given angle.<\/td><\/tr>
TANH<\/td>It is used to return the hyperbolic tangent of a number.<\/td><\/tr>
VAR.P<\/td>It is used to return the variance of the entire population.<\/td><\/tr>
VAR.S<\/td>It is used to return the variance of a sample population.<\/td><\/tr>
VARX.P<\/td>It is used to return the variance of the entire population.<\/td><\/tr>
VARX.S<\/td>It is used to return the variance of a sample population.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Learn more about: Statistical Function DAX<\/a><\/p>\n\n\n\n

\"Microsoft<\/a><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"

Data Analysis Expressions (DAX) facilitates with many functions used for creating aggregations including sums, counts, and averages. However, these functions are more like the aggregation functions used by Microsoft Excel. We shall now list the statistical functions used for aggregation provided in DAX. Function Description APPROXIMATEDISTINCTCOUNT It is used to return the\u00a0approximate\u00a0number of rows that…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[174],"tags":[1830,3955,3954],"class_list":["post-33789","page","type-page","status-publish","hentry","category-microsoft-azure","tag-da-100-study-guide","tag-microsoft-exam-da-100-exam-questions","tag-microsoft-exam-da-100-free-practice-test"],"acf":[],"yoast_head":"\nStatistical Functions DAX - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Learn more about the various Statistical Functions with online tutorial and free practice test. Start Prparing for Microsoft Exam DA-100 Now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/statistical-functions-dax\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Statistical Functions DAX - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Learn more about the various Statistical Functions with online tutorial and free practice test. Start Prparing for Microsoft Exam DA-100 Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/statistical-functions-dax\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-23T13:16:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png\" \/>\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=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/statistical-functions-dax\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/statistical-functions-dax\/\",\"name\":\"Statistical Functions DAX - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2021-01-23T13:16:39+00:00\",\"dateModified\":\"2021-01-23T13:16:41+00:00\",\"description\":\"Learn more about the various Statistical Functions with online tutorial and free practice test. Start Prparing for Microsoft Exam DA-100 Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/statistical-functions-dax\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/statistical-functions-dax\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/statistical-functions-dax\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Statistical Functions DAX\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Statistical Functions DAX - Testprep Training Tutorials","description":"Learn more about the various Statistical Functions with online tutorial and free practice test. Start Prparing for Microsoft Exam DA-100 Now!","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:\/\/www.testpreptraining.ai\/tutorial\/statistical-functions-dax\/","og_locale":"en_US","og_type":"article","og_title":"Statistical Functions DAX - Testprep Training Tutorials","og_description":"Learn more about the various Statistical Functions with online tutorial and free practice test. Start Prparing for Microsoft Exam DA-100 Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/statistical-functions-dax\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2021-01-23T13:16:41+00:00","og_image":[{"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/statistical-functions-dax\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/statistical-functions-dax\/","name":"Statistical Functions DAX - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2021-01-23T13:16:39+00:00","dateModified":"2021-01-23T13:16:41+00:00","description":"Learn more about the various Statistical Functions with online tutorial and free practice test. Start Prparing for Microsoft Exam DA-100 Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/statistical-functions-dax\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/statistical-functions-dax\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/statistical-functions-dax\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Statistical Functions DAX"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/33789","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=33789"}],"version-history":[{"count":3,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/33789\/revisions"}],"predecessor-version":[{"id":33792,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/33789\/revisions\/33792"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=33789"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=33789"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=33789"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}