DAX

The MINX function in DAX is an aggregation function that calculates the minimum value of an expression evaluated over a table. Unlike the basic MIN function, which directly calculates the…

The LASTDATE function in DAX is a time-intelligence function used to return the last date in the current context for a specified column containing date values. This function is particularly…

The FIRSTNONBLANK function in DAX is used to return the first non-blank value in a column or expression based on the current filter context. It is particularly useful for identifying…

The CONCATENATEX function in DAX is a powerful text aggregation function used to concatenate (combine) text values from a table or expression into a single string. It allows you to…

The ADDCOLUMNS function in DAX adds calculated columns to a table by evaluating expressions for each row. It returns a new table that includes the original columns and the additional…

The PATHLENGTH function in DAX is a utility function designed for parent-child hierarchies. It is used to calculate the number of levels in a hierarchical path, which is often represented…

The ALLSELECTED function in DAX returns all rows in a table or column while retaining filters applied by slicers or visuals in the current report. Unlike ALL, it respects outer…

The RELATEDTABLE function in DAX is used to retrieve a filtered table that contains all rows from a related table. This relationship is established through existing model relationships, such as…

The AND function in DAX is a logical function that checks whether two conditions are both TRUE. It returns TRUE if both conditions evaluate to TRUE; otherwise, it returns FALSE.…

The OR function in DAX (Data Analysis Expressions) is a logical operator that returns TRUE if either or both of the conditions are satisfied, and FALSE otherwise. It is widely…