Using SelectColumns() To Alias Columns In DAX

Chris Webb's BI Blog

A few years ago I wrote this post on how to alias columns in a table in DAX, using a combination of AddColumns() and Summarize(). The good news is that in Excel 2016/the Power BI Designer/SSAS Tabular 2016 there’s a new DAX function specifically for this purpose: SelectColumns(). Here’s an example of how it can be used:

Imagine you have the following source table, called Products:


You can write a DAX query to get all the rows and columns from this table like so:

Here’s the output of that query in DAX Studio (and remember, DAX Studio can connect to data loaded into the Power BI Designer, which is what I’m doing here):


You can alias the columns in this table using SelectColumns() very easily, like so:

Here’s the output:


The syntax for SelectColumns() is straightforward: the first parameter is a table expression, and after that there are pairs of…

View original post 133 more words