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.
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.
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.
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.
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
- 2
- 3
- 4