Page 52 of 1689 results for DAX
  • 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

  • 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

Show more