Forum Discussion
Surya1
8 years agoHelper I
dax
I have a table col a colb x 0 x 1 y 2 y 0 y 1 z 0 I want to create a new table New Table col A col B(...
- 8 years ago
Hi Surya1,
In your scenario, you can use SUMMARIZE() function to create a new calculated table. Please refer to following sample:
Table-2 = SUMMARIZE ( 'Table-1', 'Table-1'[col a], "col B", SUM ( 'Table-1'[col b] ) )
Thanks,
Xi Jin.
v-xjiin-msft
8 years agoSolution Sage
Hi Surya1,
In your scenario, you can use SUMMARIZE() function to create a new calculated table. Please refer to following sample:
Table-2 = SUMMARIZE ( 'Table-1', 'Table-1'[col a], "col B", SUM ( 'Table-1'[col b] ) )
Thanks,
Xi Jin.