{"active":true,"blog_title":null,"blog_url":null,"feature_description":"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/>\n```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;```","feature_name":"ANY_VALUE function","last_modified":"2026-03-26","product_id":"fa3a73cd-dcd6-ee11-9079-000d3a310f67","product_name":"Data Warehouse","release_date":"2026-03-23","release_item_id":"c877e5fa-edb8-f011-bbd3-000d3a30273e","release_status":"Shipped","release_type":"General availability"}