SAMEPERIODLASTYEAR Function DAX
SAMEPERIODLASTYEAR is a Power BI time intelligence function in DAX which returns a table that contains a column of dates in the current selection of… Read More »SAMEPERIODLASTYEAR Function 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.
SAMEPERIODLASTYEAR is a Power BI time intelligence function in DAX which returns a table that contains a column of dates in the current selection of… Read More »SAMEPERIODLASTYEAR Function DAX
![]()
TOPN function is a Power BI table manipulation function in DAX which returns the top n records from table. If you specify the number 0… Read More »TOPN Function DAX
![]()
Filter is a Power BI filter functions in DAX which returns a table that represents a subset of another table or expression. It filter the… Read More »FILTER Function DAX
![]()
USERRELATIONSHIP function is a Power BI Relationship function in DAX which Specifies the relationship to be used in a specific calculation as the one that… Read More »USERRELATIONSHIP Function DAX
![]()
GENERATESERIES function is a Power BI Table Manipulation function in DAX which returns a table with one column which contains sequential values from start to… Read More »GENERATESERIES Function DAX
![]()
RELATED function is a Power BI Relationship function in DAX which returns a related value from another table. The RELATED function requires that a relationship… Read More »RELATED 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 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
![]()
CONTAINS function is a Power BI Information function in DAX which returns TRUE if there exists at least one row where all columns have specified… Read More »CONTAINS Function DAX
![]()
CALENDARAUTO function 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 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
![]()
ADDCOLUMNS is a POWER BI Table Manipulation Functions in DAX which is used to add a calculated columns in table. Basically, ADDCOUMNS returns a table… Read More »ADDCOLUMNS function DAX
![]()
DATATABLE function is a Power BI Table manipulation function in DAX which allows us to create a table. Using Datatable function, You can define column… Read More »DATATABLE 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 function is a Power Bi Table Manipulation function in DAX which returns a summary table over a set of groups.
![]()
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 is a Power BI DAX TEXT function that allows to replace existing text with new text in a text string.
![]()
UNICHAR function is a power BI DAX text function that returns Unicode character referenced by the numeric value.
![]()
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 is a power bi DAX mathematical and trig functions that performs the division and returns alternate result or BLANK() on division by 0.
![]()