-
ABS: Returns the absolute value of a number. https://dax.guide/abs/ SIGN: Returns the sign of a number. https://dax.guide/nextmonth/ Watch now
-
This video describes how to use variables to optimize the performance of DAX expressions containing multiple instances of the same measure or the same sub-expression. There are two related articles and downloads: Optimizing duplicated DAX expressions using variables Optimizing IF… Watch now
-
FIRSTDATE: Returns first non blank date. https://dax.guide/firstdate/ LASTDATE: Returns last non blank date. https://dax.guide/lastdate/ Watch now
-
DATEADD: Moves the given set of dates by a specified interval. https://dax.guide/dateadd/ SAMEPERIODLASTYEAR : Returns a set of dates in the current selection from the previous year. https://dax.guide/sameperiodlastyear/ Watch now
-
ISEVEN: Returns TRUE if number is even, or FALSE if number is odd. https://dax.guide/iseven/ ISODD: Returns TRUE if number is odd, or FALSE if number is even. https://dax.guide/isodd/ Watch now
-
ISFILTERED: Returns true when there are direct filters on the specified column. https://dax.guide/isfiltered/ ISCROSSFILTERED: Returns true when the specified table or column is crossfiltered. https://dax.guide/iscrossfiltered/ Watch now
-
ISAFTER: Returns true if the list of Value1 parameters compares strictly after the list of Value2 parameters. https://dax.guide/isafter/ ISONORAFTER: The IsOnOrAfter function is a boolean function that emulates the behavior of Start At clause and returns true for a row… Watch now
-
CONTAINSSTRING: Returns TRUE if one text string contains another text string. CONTAINSSTRING is not case-sensitive, but it is accent-sensitive. https://dax.guide/containsstring/ CONTAINSSTRINGEXACT: Returns TRUE if one text string contains another text string. CONTAINSSTRINGEXACT is case-sensitive and accent-sensitive. https://dax.guide/containsstringexact/ Watch now
-
CONTAINS: Returns TRUE if there exists at least one row where all columns have specified values. https://dax.guide/contains/ CONTAINSROW: Returns TRUE if there exists at least one row where all columns have specified values. https://dax.guide/containsrow/ Watch now
-
CALCULATE: Evaluates an expression in a context modified by filters. https://dax.guide/calculate/ CALCULATETABLE: Evaluates a table expression in a context modified by filters. https://dax.guide/calculatetable/ Watch now