Formatting a column

Question

Hi all,&nbsp;I had a question about the following, I want to format a column like this:&nbsp;&nbsp;12303213&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;--&gt;&nbsp;123_3213&nbsp; &nbsp;123056453&nbsp; &nbsp; &nbsp; &nbsp;--&gt;&nbsp;123_56453&nbsp;&nbsp;12309801&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;--&gt;&nbsp;123_9801&nbsp;&nbsp;1230648112&nbsp; &nbsp; &nbsp;--&gt;&nbsp;123_648112&nbsp;&nbsp;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.&nbsp;Regards,L.Meijdam&nbsp;

greg_deckler · Accepted Answer

I would acutally use the REPLACE function:&nbsp;https://msdn.microsoft.com/en-us/library/ee634374.aspx&nbsp;

Forum Discussion

Formatting a column

2 Replies

Related content

3D Format Column Chart

Legend Format for Line Column Chart

Matrix columns formatting

Format a Time Column

Paginated Report column formatting