DAX Linkback table with specific columns

[cr731]

I have a table in my data model that I want to return to the Excel worksheet through a linkback table, but I only want to bring back two columns.

How can I do this? If I right-click the table and go to Edit DAX, it just says the table name "Dimension_Customer" and I want to return just "Customer Name" and "Customer Address" to conserve workbook space.

Thanks

 

[tallan]

Change the drop-down for Command Type from "Table" to "DAX" and then in the Expression edit box write:

EVALUATE


SUMMARIZE ( Dimension_Customer, Dimension_Customer[Customer Name], Dimension_Customer[Customer Address] )


You can read up here on the EVALUATE statement: Flat to Star Transformation using DAX Query - PowerPivotPro

Tom
PowerPivotPro - Transforming your Business with Power Pivot and Power BI

 

[cr731]

Do you know if "Dimensions" is a reserved word in DAX? I have a table named Dimensions and the above does not work for me if I do

EVALUATE

SUMMARIZE( Dimensions, Dimensions[CustomerName], Dimensions[ProductName] )

I get an error "The query did not run or the Data Model could not be accessed. Here's the error message we got: The syntax for 'Dimensions' is incorrect (EVALUATE Dimensions)."

If I try this with any other table name, it works. But Dimensions seems to cause trouble.

 

[tallan]

Try surrounding Dimensions with single quote marks: 'Dimensions', 'Dimensions'[CustomerName], 'Dimensions'[ProductName]

Please respond back if the single quotes make a difference. I did not see a list of DAX reserved keywords that included Dimensions, so it would be helpful to others following your post to know.

Tom
PowerPivotPro - Transforming your Business with Power Pivot and Power BI

 

[cr731]

Try surrounding Dimensions with single quote marks: 'Dimensions', 'Dimensions'[CustomerName], 'Dimensions'[ProductName]

Please respond back if the single quotes make a difference. I did not see a list of DAX reserved keywords that included Dimensions, so it would be helpful to others following your post to know.

Tom
PowerPivotPro - Transforming your Business with Power Pivot and Power BI

Thanks! That did the trick - I would have never thought to do that.