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
Home » Power BI Tutorials »
Power BI Tutorials
Power BI Tutorials : Power BI is a business analytics service by Microsoft. It provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.
Create Index column using a Power Query
Create Index column using a Power Query in Power Bi
Using a Power Query, you can add index column to your data that serves as a row counter to rows in data table, it is really a best feature of power query.
SUMMARIZECOLUMNS Functon DAX
SUMMARIZECOLUMNS function is a Power Bi Table Manipulation function in DAX which returns a summary table over a set of groups.
Report ToolTip page in Power BI
Power Bi allows us to create a report tooltip pages, means you can access a report page inside tooltip.
So for any selected records on visuals you can display more information by displaying a report page as a tooltip.
COUNT FUNCTION DAX
The COUNT function is a power bi DAX statistica function which counts the number of rows in a table.
It returns a single interger value.
SWITCH FUNCTION DAX
SWITCH() Function is a power bi dax logical function which evaluates an expression against a list of values and returns different results depending on the value of an expression.
It returns a scalar value of any type.
IF Function DAX
IF function is a Power BI logical function in DAX that checks whether a condition is satisfied, and returns one value in case of TRUE else another value in case of FALSE.
SUM() Function DAX
SUM() function is a power bi dax math function that adds up all the values in a single column that you specify after applying all filters.
SUMX Function DAX
SUMX() is a power bi DAX Math function that returns the sum of an expression evaluated for each row in a table. It returns a decimal number.
It goes through a table, row by row to complete the evaluation after filter is applied.
Only the numbers in the column are counted. Blanks, logical values, and text are ignored.
It can be used to evaluate expression over multiple columns as it has the ability to work row by row.
CALCULATETABLE function DAX
CALCULATETABLE function is a power bi filter function in DAX that evaluates a table expression in a context modified by the given filters. It returns a table of values.
DAX SYNTAX
CALCULATETABLE(
ALL Function DAX
ALL is a Power Bi DAX filter function that returns all the rows in a table or all the values in a column, ignoring any filters that might have been applied.
- « Previous
- 1
- …
- 3
- 4
- 5