Home » POWER BI » DAX

# DAX

Power Bi Data Analysis Expression (DAX), According to Microsoft Documentation DAX is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. Stated more simply, DAX helps you create new information from data already in your model.

## ISBLANK Function DAX

ISBLANK Function is a POWER BI Information function in DAX that checks whether a value is blank, and returns TRUE If value is blank else… Read More »ISBLANK Function DAX

## SELECTEDVALUE Function DAX

SELECTEDVALUE Function is Power BI Filter Functions in DAX which returns the value when there is only one value in the specified column else it… Read More »SELECTEDVALUE Function DAX

## CALENDARAUTO Function DAX

CALENDARAUTO funtion is a Power BI Date and Time Function in DAX which returns table with single column which contains a contiguous set of dates.… Read More »CALENDARAUTO Function DAX

## FIND Function DAX

FIND Function is a Power BI TEXT function in DAX which returns the starting position of one text string within another text string. FIND function… Read More »FIND Function DAX

## CONCATENATEX Function DAX

CONCATENATEX function is a Power Bi text function in DAX, which evaluates expression for each row on the table, then return the concatenation of those values in a single string result, separated by the specified delimiter

## SUMMARIZECOLUMNS Functon DAX

SUMMARIZECOLUMNS function is a Power Bi Table Manipulation function in DAX which returns a summary table over a set of groups.

## VALUES function DAX

VALUES function is a Power Bi table manipulation function in DAX which removes duplicate values and return unique values. A blank values can be added.

## SUBSTITUE Function DAX

SUBSTITUE Function DAX

SUBSTITUE function is a Power BI DAX TEXT function that allows to replace existing text with new text in a text string.

## Unichar function DAX

UNICHAR function is a power BI DAX text function that returns Unicode character referenced by the numeric value.

## SUMMARIZE Function DAX

The SUMMARIZE function is a Power Bi table manipulation function in DAX that allows you to create a customised table directly in Power BI, without using Power Query.

## DIVIDE Function DAX

DIVIDE function is a power bi DAX mathematical and trig functions that performs the division and returns alternate result or BLANK() on division by 0.