Forum Discussion

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

8 years ago

You could add a calculated column as follows.

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

Community Support

8 years ago

You could add a calculated column as follows.

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

Regular Visitor

8 years ago

Thank you so much.