Selects the rows that meet the condition function. Select the rows in the table where the values in [CustomerID] column are greater than 2. Table.SelectRows(Table ...
Last year I blogged about handling multi-select scenarios for dynamic M parameters. Since then support for “Select All” has been added (see here) but since a regular slicer with no items selected ...
#""Filtered Rows"" = Table.SelectRows(Table, each Date.Year([Order Date Key]) = $year), KeepColumns = Table.SelectColumns(#""Filtered Rows"",{""Order Date Key ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results