- How do you find duplicates in power bi Dax?
- What is the difference between distinct () and values () in DAX?
How do you find duplicates in power bi Dax?
RE: Identify duplicates in Dax or M
One way is to create Duplicate table of source table and then group then columns you want and add new column as "Duplicate" ... then create a Column in Source table with "Related" and reference duplicate column in source.
What is the difference between distinct () and values () in DAX?
The DISTINCT function allows a column name or any valid table expression to be its argument but the VALUES function only accepts a column name or a table name as the argument.