Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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] )
Regards,
Xiaoxin Sheng
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] )
Regards,
Xiaoxin Sheng
If I have another table of 'old column name', 'new column name' how can I use that to rename a column?
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |