[Solved] What will be the output of this Power Query step?Table.Distinct(Source, {"CustomerID"})Assuming Source has duplicate CustomerID values. | Power BI

Power BI - Power Query Editor

What will be the output of this Power Query step?

Table.Distinct(Source, {"CustomerID"})

Assuming Source has duplicate CustomerID values.

ATable with all rows including duplicates

BTable with unique CustomerID rows only

CTable with only duplicate CustomerID rows

DTable with CustomerID column removed

Step-by-Step Solution

Solution:

Step 1: Understand Table.Distinct function
This function removes duplicate rows based on specified columns.
Step 2: Apply to CustomerID column
It keeps only unique CustomerID rows, removing duplicates.
Final Answer:
Table with unique CustomerID rows only -> Option B
Quick Check:
Table.Distinct = Remove duplicates [OK]

Quick Trick: Table.Distinct removes duplicate rows [OK]

Common Mistakes:

Master "Power Query Editor" in Power BI

9 interactive learning modes - each teaches the same concept differently

More Power BI Quizzes

What will be the output of this Power Query step?