Forum Discussion

Rigolleto's avatar
Rigolleto
Icon for Resolver I rankResolver I
6 years ago
Solved

Parsing 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...
Tips and Tricks
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

So if display column1 along with this formula you will get output

Measure = CONCATENATEX (table,table[Column2])