Question

You are building a reporting view in a Fabric warehouse. The finance team needs a query against the FactSales table that returns each daily sales amount along with a cumulative running total of sales within each region, ordered by date. You want to compute the running total without collapsing the individual daily rows into aggregated groups. Which T-SQL construct should you use?

Accepted Answer

SUM(SalesAmount) OVER (PARTITION BY Region ORDER BY SaleDate ROWS UNBOUNDED PRECEDING)

Answer

SUM(SalesAmount) with a GROUP BY Region, SaleDate clause

Answer

A self-join of FactSales on Region where the joined SaleDate is less than or equal to the current row's SaleDate

Answer

SUM(SalesAmount) OVER (PARTITION BY Region) without an ORDER BY clause