-
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
-
ALL: Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. https://dax.guide/all/ ALLNOBLANKROW: Returns all the rows except blank row in a table, or all the values in… Watch now
-
EARLIER: Returns the value in the column prior to the specified number of table scans. https://dax.guide/earlier/ EARLIEST: Returns the value in the column for the very first point at which there was a row context. https://dax.guide/earliest/ Watch now
-
CALENDAR: Returns a table with one column of all dates between StartDate and EndDate. https://dax.guide/calendar/ CALENDARAUTO: Returns a table with one column of dates calculated from the model automatically. https://dax.guide/calendarauto/ Watch now
-
EDATE: Returns the date that is the indicated number of months before or after the start date. https://dax.guide/edate/ EOMONTH: Returns the date in datetime format of the last day of the month before or after a specified number of months.… Watch now
-
DATEDIFF: Returns the number of units (unit specified in Interval) between the input two dates. https://dax.guide/datediff/ YEARFRAC: Returns the year fraction representing the number of whole days between start_date and end_date. https://dax.guide/yearfrac/ Watch now