« Office for Android Phones | TEXT FUNCTIONS (DAX) » |
Statistical Functions (DAX)
powerpivot, DAX FunctionsHi there,
In this post, we will discuss about one of the types of DAX Functions. These functions basically supports the needs of Business Intelligence Analysis. These functions will help to manipulate data using time periods.
TYPES OF DAX:
- DATE AND TIME FUNCTIONS
- FILTER FUNCTIONS
- INFORMATION FUNCTIONS
- LOGICAL FUNCTIONS
- MATHEMATICAL AND TRIGNOMETRIC FUNCTIONS
- STATISTICAL FUNCTIONS
- TEXT FUNCTIONS
- TIME INTELLIGENCE FUNCTIONS
...
- ADDCOLUMNS: This function adds calculated columns to the given table of data.
- AVERAGE: This function calculates the average of a particular column.
- AVERAGEA: This function returns the average of a specified column including numeric and non-numeric.
- AVERAGEX: This function calculates the average of a set of expressions evaluated over a table.
- COUNT: This function counts the numbers in a column.
- COUNTA: This function counts the number of non-blank cells in a column. Non-Blank includes text, dates and logical values,.
- COUNTAX: This function counts non-blank results when evaluating the result of an expression over a table.
- COUNTBLANK: This function counts the number of blank cells in a column.
- COUNTROWS: This function returns the number of rows in the specified table.
- COUNTX: This function counts the number of rows that contain a number or an expression that evaluates to a number, when evaluating an expression over a table.
- CROSSJOIN: This function returns a table that contains the Cartesian product of all rows from all tables in the arguments.
- DISTINCTCOUNT: This function counts the number of unique cells in a column.
- GENERATE: This function returns a table with the Cartesian product between each row in table 1 and the table that results from evaluating table2 in the context of the current row from table1.
- GENERATEALL: This function returns a table with Cartesian product between each row in table1 and the table that results from evaluating table 2 in the context of the current row from table 1.
- MAX: This function returns the largest numeric value in a column.
- MAXA: This function retunrs the largest value in a column, considering logical values and blanks.
- MAXX: This function evaluates an expression for each row of a table and returns the largest numeric value.
- MIN: This function returns a smallest value in a column, excludes logical values and text.
- MINA: This function returns a smallest value in a column including any logical values and numbers represented as text.
- MINX: This function returns the smallest numeric value that results from evaluating an expression for each row of a table.
- RANK.EQ: This function returns the position of a value based on selection.
- RANKX: This function returns the ranking of a number in a list of numbers for each row in the table argument.
- ROW: This function returns a table with a single row containing values that result from the expressions given to each column.
- STDEV.S: This function returns the standard deviation of a sample population.
- STDEV.P: This function returns a standard deviation of an entire population.
- STDEVX.S: This function returns the standard deviation of a sample population.
- STDEVX.P: This function returns a standard deviation of an entire population.
- SUMMARIZE: This function returns a summary table for the requested totals over a set of groups.
- TOPN: This function returns the top N rows of the specified table.
- VAR.S: This function returns the variance of a sample population.
- VAR.P: This function returns the variance of the entire population.
- VARX.S: This function returns the variance of a sample population.
- VARX.P: This function returns the variance of the entire population.
- SAMPLE: This function returns a sample of N rows from the specified table.
There are 34 DAX Statistical Functions available to manipulate the pivot data.
DID YOU USE DAX FUNCTIONS?
Please do share your views and thoughts about this posts in the below comments section.
If you like this post, please share it on your social networking sites by clicking on the icons placed around the blog.
To receive such updates to your inbox, REGISTER here for free.
SOME IMPORTANT LINKS:
Thanks,
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments