-
AND: Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE. https://dax.guide/and/ OR: Returns TRUE if any of the arguments are TRUE, and returns FALSE if all arguments are FALSE. https://dax.guide/or/ NOT: Changes FALSE to TRUE,… Watch now
-
LEFT: Returns the specified number of characters from the start of a text string. https://dax.guide/left/ RIGHT: Returns the specified number of characters from the end of a text string. https://dax.guide/right/ MID: Returns a string of characters from the middle of… Watch now
-
VAR.P: Calculates variance based on the entire population. https://dax.guide/var-p/ VAR.S: Estimates variance based on a sample. https://dax.guide/var-s/ VARX.P: Estimates variance based on the entire population that results from evaluating an expression for each row of a table. https://dax.guide/varx-p/ VARX.S: Estimates… Watch now
-
STDEV.P: Calculates standard deviation based on the entire population given as arguments. https://dax.guide/stdev-p/ STDEV.S: Estimates standard deviation based on a sample. https://dax.guide/stdev-s/ STDEVX.P: Estimates standard deviation based on the entire population that results from evaluating an expression for each row… Watch now
-
PERCENTILE.EXC: Returns the k-th (exclusive) percentile of values in a column. https://dax.guide/percentile-exc/ PERCENTILE.INC: Returns the k-th (inclusive) percentile of values in a column. https://dax.guide/percentile-inc/ PERCENTILEX.EXC: Returns the k-th (exclusive) percentile of an expression values in a table. https://dax.guide/percentilex-exc/ PERCENTILEX.INC: Returns… Watch now
-
NORM.DIST: Returns the normal distribution for the specified mean and standard deviation. https://dax.guide/norm-dist/ NORM.INV: Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation. https://dax.guide/norm-inv/ NORM.S.DIST: Returns the standard normal distribution (has a mean of… Watch now
-
CHISQ.DIST: Returns the chi-squared distribution. https://dax.guide/chisq-dist/ CHISQ.DIST.RT: Returns the right-tailed probability of the chi-squared distribution. https://dax.guide/chisq-dist-rt/ CHISQ.INV: Returns the inverse of the left-tailed probability of the chi-squared distribution. https://dax.guide/chisq-inv/ CHISQ.INV.RT: Returns the inverse of the right-tailed probability of the chi-squared… Watch now
-
The “greater than” operator returns TRUE when the first argument is greater than the second argument. https://dax.guide/op/greater-than/ The “greater than or equal to” operator returns TRUE when the first argument is greater than or equal to the second argument. https://dax.guide/op/greater-than-or-equal-to/… Watch now
-
The addition operator + sums two numbers. https://dax.guide/op/addition/ The subtraction operator – subtracts the second argument from the first one. https://dax.guide/op/subtraction/ The multiplication operator * multiply two numbers. https://dax.guide/op/multiplication/ The division operator / divides the numerator by the denominator, generating… Watch now
-
LN: Returns the natural logarithm of a number. https://dax.guide/ln/ LOG: Returns the logarithm of a number to the base you specify. https://dax.guide/log/ LOG10: Returns the base-10 logarithm of a number. https://dax.guide/log10/ EXP: Returns e raised to the power of a… Watch now