Microsoft Fabric adds ANY_VALUE function to simplify data grouping

Microsoft Fabric Data Warehouse now includes ANY_VALUE function. It returns an arbitrary value from grouped data without calculations like MIN/MAX on text. Previously, GROUP BY required grouping descriptive columns or fake aggregates, wasting resources on sorting. ANY_VALUE assumes identical values, enabling readable queries and efficient data prep for Power BI.