Formatting a column

[Anonymous]

Hi all,

I had a question about the following, I want to format a column like this: 

12303213         --> 123_3213   

123056453       --> 123_56453  

12309801         --> 123_9801  

1230648112     --> 123_648112 

So basically I want to change the 4th character to a "_" the length values in the column can be different like shown above. I guess this has to be done using the FORMAT() function but I could'nt figure out how to write the DAX code for it.

Regards,

L.Meijdam 

[Greg_Deckler · Accepted solution]

I would acutally use the REPLACE function:

https://msdn.microsoft.com/en-us/library/ee634374.aspx

[Anonymous]

Hi @Greg_Deckler,

Thanks I diddnt know that the REPLACE function existed, thanks for pointing me in the right direction !

Regards,

L.Meijdam