Power bi distinct values in column
Citrix workspace ipad microphone
List.Distinct(list as list, optional equationCriteria as any) as list About. Returns a list that contains all the values in list list with duplicates removed. If the list is empty, the result is an empty list. Example 1. Remove the duplicates from the list {1, 1, 2, 3, 3, 3}. List.Distinct({1, 1, 2, 3, 3, 3})
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. See below example: Original table . Ref1 Ref2 Amount. CDD ROO 34. CDD ROO 567. ABB TEE 467. ABB TEE 45