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

[geddadac]

hi friends please help me write dax query for above requirement

[v-chuncz-msft · Accepted solution]

@geddadac,

You could add a calculated column as follows.

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

[geddadac]

Thank you so much.