Why DAX Window Functions Are Important For Performance In Power BI DirectQuery Mode

DAX window functions can result in simpler, more efficient SQL when using Power BI DirectQuery mode and a greater likelihood that aggregations are used