0
0
Power BIbi_tool~10 mins

VALUES and DISTINCT in Power BI - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This table lists products sold, with some repeated names.

CellValue
A1Product
A2Apple
A3Banana
A4Apple
A5Orange
A6Banana
A7Grape
Formula Trace
VALUES('Table'[Product])
Step 1: Table[Product] column values
Step 2: VALUES('Table'[Product])
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 distinct products from the Product column without duplicates.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the VALUES function return when applied to the Product column?
AAll products including duplicates
BOnly the first product in the list
CA list of unique products without duplicates
DThe count of products
Key Result
VALUES returns the distinct values from a column, similar to DISTINCT.