2020-03-15 UPDATE: The original version of this article published in 2011 did not mention SELECTCOLUMNS, which was introduced in 2015. This article was rewritten in 2020 to provide updated coverage of projection functions in DAX.
The projection is provided by this classic SELECT in SQL: