Forum Discussion

Cednok's avatar
Cednok
Frequent Visitor
5 years ago
Solved

remove quotes

i haves a lote of values in quotes 

 

 

Wich dax formula i can use for removing quotes ?

 

thank you for your help

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    In Dax, you'd have to create a calculated column along the lines of:

    Column = 
var _FirstColon = FIND(UNICHAR(34),'Table'[Column1],1)
var _Len = LEN('Table'[Column1])-2
return
MID('Table'[Column1], _FirstColon+1,_Len)

     

    In the power query editor, you could just do a find and replace.