[Solved] What will be the output of this Power Query M code?Table.Distinct(#"Sales Data", {"OrderID"})Assuming the Sales Data table has 200 rows with 150 unique OrderIDs. | Power BI

Power BI - Data Cleaning with Power Query

What will be the output of this Power Query M code?

Table.Distinct(#"Sales Data", {"OrderID"})

Assuming the Sales Data table has 200 rows with 150 unique OrderIDs.

AA table with 200 rows

BA table with 150 rows, duplicates removed by OrderID

CA table with 50 rows

DAn error because syntax is wrong

Step-by-Step Solution

Solution:

Step 1: Understand Table.Distinct function
Table.Distinct removes duplicate rows based on specified columns, here OrderID.
Step 2: Apply to data
Since there are 150 unique OrderIDs, the resulting table will have 150 rows.
Final Answer:
Table with 150 rows, duplicates removed by OrderID -> Option B
Quick Check:
Table.Distinct removes duplicates by column(s) [OK]

Quick Trick: Table.Distinct removes duplicates by given columns [OK]

Common Mistakes:

Master "Data Cleaning with Power Query" 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 M code?