Forum Discussion
How do I remove duplicates based on unique values from two columns in DAX.
How do I remove duplicates based on Name and _totals for _standardize new? For example: Name = Adam _totals = 5 Standardize new = 19.29%. How can 19.29% show only once for unique name and _to...
Select these two columns, then "Remove Duplicates". You will end up with distinct values on these two columns, and random values on all other columns.
This is DAX not power query.
use SUMMARIZE, SUMMARIZECOLUMS or GROUPBY on these two columns.