Shipped General availability Date: 2026-03-23
Fabric Data Warehouse will introduce the ANY_VALUE() function.<br/>This function returns a value from a column within each group when all values in that group are the same, without requiring explicit aggregation logic like MIN() or MAX().<br/>It's ideal for scenarios where grouped columns contain identical values, and you simply need one of them for reporting or joining purposes.This makes queries cleaner and easier to write while preserving performance and correctness.<br/> ```SELECT c.CustomerID, ANY_VALUE(c.FirstName + ' ' + c.LastName) AS CustomerName, ANY_VALUE(c.CompanyName) AS Company, ANY_VALUE(c.EmailAddress) AS Email, ANY_VALUE(c.Phone) AS Phone, COUNT(soh.SalesOrderID) AS OrderCountFROM SalesLT.Customer AS cJOIN SalesLT.SalesOrderHeader AS soh ON c.CustomerID = soh.CustomerIDGROUP BY c.CustomerID;```