Syntax
List.Single(list as list) as any
Description
If there is only one item in the list list, returns that item. If there is more than one item or the list is empty, the function throws an exception.
Reference Data
https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference