Crucial Exams

Microsoft Power BI Data Analyst Practice Question

During data preparation in Power Query, you connect to a SQL Server view that returns columns CustomerID, SalesDate, and LineTotal. You must create a table that lists each CustomerID together with the sum of LineTotal and the number of transactions. The result has to be produced in a single transformation step, stay query-foldable, and avoid extra queries. What should you do?

  • Add a Table.Buffer step before applying Table.Group to aggregate LineTotal and transaction count.

  • Duplicate the query, use one duplicate to Group By and sum LineTotal, use the other to Group By and count rows, then merge the results.

  • Open the Group By dialog, switch to Advanced, group on CustomerID, and add two aggregations in the same step: Sum of LineTotal and Count Rows.

  • Load the view without transformations and create a DAX table with the SUMMARIZE function to calculate the totals and counts.

Microsoft Power BI Data Analyst
Prepare the data
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot