0
0
Power BIbi_tool~10 mins

Removing duplicates in Power BI - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This table lists products with some duplicates.

CellValue
A1Product
A2Apple
A3Banana
A4Apple
A5Orange
A6Banana
A7Grape
Formula Trace
DISTINCT('Products'[Product])
Step 1: 'Products'[Product]
Step 2: DISTINCT(["Apple", "Banana", "Apple", "Orange", "Banana", "Grape"])
Cell Reference Map
   A   
1 Product
2 Apple 
3 Banana
4 Apple 
5 Orange
6 Banana
7 Grape
The formula references the 'Product' column from rows 2 to 7.
Result
   B   
1 Unique Products
2 Apple 
3 Banana
4 Orange
5 Grape
The result shows the unique products without duplicates.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the DISTINCT function do in this formula?
ACounts the number of products
BRemoves duplicate values from the list
CSorts the list alphabetically
DFilters products starting with 'A'
Key Result
DISTINCT returns a list of unique values from a column, removing duplicates.