Question

You are an analyst working in a Fabric Warehouse. Business users have asked for a table that shows total sales amount and average order value per product category. You want to build this transformation quickly without writing T-SQL by hand, using a low-code interface that also lets you preview results and later copy the generated SQL. Which approach in the Fabric portal should you use?

Accepted Answer

Open the Visual Query Editor on the warehouse, drag the sales table onto the canvas, and use the Group by operation to add SUM and AVG aggregations grouped by product category.

Answer

Create a Dataflow Gen2 and add a Group by step, then load the aggregated output as a new warehouse table for reporting.

Answer

Open a new KQL queryset against the warehouse and use the summarize operator to compute the aggregations by category.

Answer

Create a DAX measure in a semantic model that uses SUMX and AVERAGEX over the sales table grouped by category.