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.
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.