Forum Discussion

geddadac's avatar
geddadac
Regular Visitor
8 years ago
Solved

how to split column value into another new column by using dax

 

 

 

 

 

 

 

 

 

 

 

 

hi friends please help me write dax query for above requirement

 

  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    geddadac,

     

    You could add a calculated column as follows.

    Column =
VAR p =
    SEARCH ( "-", Table1[Column1],, 0 )
RETURN
    REPLACE ( Table1[Column1], 1, p, "" )

2 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    geddadac,

     

    You could add a calculated column as follows.

    Column =
VAR p =
    SEARCH ( "-", Table1[Column1],, 0 )
RETURN
    REPLACE ( Table1[Column1], 1, p, "" )