Summarizecolumns with rename of column

[xanhdieu]

I want to rename the column to something else with DAX below. 

the cntry_code column to "Country Name".

EVALUATE
    SUMMARIZECOLUMNS (
        OPTMZ_GRP[cntry_code],
        "column a", SUM ('hcec_sales'[total_sales] )
    )

I've tried the addsolumns but that gave me 2 of the same columns.

EVALUATE
 ADDCOLUMNS(
    SUMMARIZECOLUMNS (  
        OPTMZ_GRP[cntry_code],
        ),
        "total_sales", SUM ('hcec_sales'[total_sales] )
    ),
    "Country Name", OPTMZ_GRP_BR_CURR_AIRPT[cntry_iso_cde]
)

cntry_code | total_sales | country Name

USA                 $150          USA 

is there a way to rename the column with just one column display?

[Anonymous · Accepted solution]

HI @xanhdieu,

I think SELECTCOLUMNS function will suitable for your requirement, it support to extract specific columns and rename them at same time.

New Table =
SELECTCOLUMNS (
    SUMMARIZECOLUMNS (
        OPTMZ_GRP[cntry_code],
        "total_sales", SUM ( 'hcec_sales'[total_sales] )
    ),
    "Country Name", [cntry_code],
    "total sales", [total_sales]
)

SELECTCOLUMNS Function (DAX)

Regards,

Xiaoxin Sheng

[Jon_vB]

Thanks!   This works ... though for a few minutes I thought it didn't.   When I first changed a field name, it gave me an error about the field name I just changed.  But that was because the old field name was in the ORDER BY clause  (it was auto-generated DAX).    Mentioning it so I see this when I hit this error again next year 🙂

[colin_sutton]

If I have another table of  'old column name', 'new column name'  how can I use that to rename a column?