Forum Discussion
Rigolleto
Resolver I
Resolver IParsing a column base on filter values
Hi There, Just to ask about the way to take one column and create a new one with the values of the first column separated by DASHES? Any one can advise me about the DAX state...
HI Rigolleto
If you want to create a calculated column, and just want to show once for each COLUMN1, you need to add an index in edit queries, then add a calculated column as below:
output1 = var _column1='Table'[COLUMN1] var _firstrow= CALCULATE(MIN('Table'[Index]),FILTER('Table','Table'[COLUMN1]=_column1)) return IF('Table'[Index]=_firstrow, CONCATENATEX( FILTER( 'Table', [COLUMN1] = EARLIER([COLUMN1]) ), [COLUMN2] ))otherwise, you could just use this simple formula:
output2 = CONCATENATEX( FILTER( 'Table', [COLUMN1] = EARLIER([COLUMN1]) ), [COLUMN2] )Result:
Regards,
Lin
v-lili6-msft
Community Support
Community SupportHI Rigolleto
If you want to create a calculated column, and just want to show once for each COLUMN1, you need to add an index in edit queries, then add a calculated column as below:
output1 =
var _column1='Table'[COLUMN1]
var _firstrow= CALCULATE(MIN('Table'[Index]),FILTER('Table','Table'[COLUMN1]=_column1))
return
IF('Table'[Index]=_firstrow, CONCATENATEX( FILTER( 'Table', [COLUMN1] = EARLIER([COLUMN1]) ), [COLUMN2] ))otherwise, you could just use this simple formula:
output2 =
CONCATENATEX( FILTER( 'Table', [COLUMN1] = EARLIER([COLUMN1]) ), [COLUMN2] )Result:
Regards,
Lin