-
UNICHAR: Returns the Unicode character that is referenced by the given numeric value. https://dax.guide/unichar/ UNICODE: Returns the number (code point) corresponding to the first character of the text. https://dax.guide/unicode/ Watch now
-
LOWER: Converts all letters in a text string to lowercase. https://dax.guide/lower/ UPPER: Converts a text string to all uppercase letters. https://dax.guide/upper/ Watch now
-
CONCATENATE: Joins two text strings into one text string. https://dax.guide/concatenate/ CONCATENATEX : Evaluates expression for each row on the table, then return the concatenation of those values in a single string result, seperated by the specified delimiter. https://dax.guide/concatenatex/ Watch now
-
NATURALINNERJOIN: Joins the Left table with right table using the Inner Join semantics. https://dax.guide/naturalinnerjoin/ NATURALLEFTOUTERJOIN: Joins the Left table with right table using the Left Outer Join semantics. https://dax.guide/naturalleftouterjoin/ Watch now
-
GENERATE: The second table expression will be evaluated for each row in the first table. Returns the crossjoin of the first table with these results. https://dax.guide/generate/ GENERATEALL: The second table expression will be evaluated for each row in the first… Watch now
-
DISTINCT: Returns distinct (unique) values in a column or from a table expression. https://dax.guide/distinct/ VALUES: Returns distinct (unique) values in a column or all the rows (including duplicates) from a table expression, in both cases with the additional blank row… Watch now
-
GROUPBY: Creates a summary the input table grouped by the specified columns. https://dax.guide/groupby/ CURRENTGROUP: Access to the (sub)table representing current group in GroupBy function. Can be used only inside GroupBy function. https://dax.guide/currentgroup/ Watch now
-
MEDIAN: Returns the 50th percentile of values in a column. https://dax.guide/median/ MEDIANX: Returns the 50th percentile of an expression values in a table. https://dax.guide/medianx/ Watch now
-
GEOMEAN: Returns geometric mean of given column reference. https://dax.guide/geomean/ GEOMEANX: Returns geometric mean of an expression values in a table. https://dax.guide/geomeanx/ Watch now
-
CONFIDENCE.NORM: Returns the confidence interval for a population mean, using a normal distribution. https://dax.guide/confidence-norm/ CONFIDENCE.T: Returns the confidence interval for a population mean, using a Student’s t distribution. https://dax.guide/confidence-t/ Watch now