DISTINCT – DAX Guide
dax.guide › distinctJan 18, 2023 · DISTINCT DAX Function (Table manipulation) DISTINCT. Returns a one column table that contains the distinct (unique) values in a column, for a column argument. Or multiple columns with distinct (unique) combination of values, for a table expression argument.
DISTINCT (table) function (DAX) - DAX | Microsoft Learn
learn.microsoft.com › en-us › daxJun 21, 2022 · DAX DISTINCT(<table>) Parameters Return value A table containing only distinct rows. Related functions There is another version of the DISTINCT function, DISTINCT (column), that takes a column name as input parameter. Example The following query: DAX EVALUATE DISTINCT( { (1, "A"), (2, "B"), (1, "A") } ) Returns table: See also Filter functions
Table.Distinct - PowerQuery M | Microsoft Learn
learn.microsoft.com › powerquery-m › table-distinctSep 15, 2022 · Removes duplicate rows from the table. An optional parameter, equationCriteria, specifies which columns of the table are tested for duplication. If equationCriteria is not specified, all columns are tested. Because Power Query sometimes offloads certain operations to backend data sources (known as folding ), and also sometimes optimizes queries by skipping operations that aren't strictly necessary, in general there's no guarantee which specific duplicate will be preserved.
Solved: create a new table with distinct values of one col ...
community.powerbi.com › t5 › DesktopApr 25, 2020 · create a new table with distinct values of one column, and the value of one other column. 04-25-2020 07:27 AM. I am struggling to achieve something which seems quite simple! I want to create a new table using DAX with distinct values of one column, and the value of one other column - in the original table there are multiple entries, but each has two different references which are the same of each row.