Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
xanhdieu
Regular Visitor

Summarizecolumns with rename of column

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?

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.