Forum Discussion

RanjanThammaiah's avatar
RanjanThammaiah
Helper V
7 years ago
Solved

Measure column replace text

Hi All,

 

Can some one tell how to replace the value of Measured Column.

 

Below is the example.

 

I have created a measured column based one some formula, And there is text called "Oceania" i want to replace with blank from all the rows.

 

Regards,

Ranjan

 

Regards,

Ranjan

 

Tips and Tricks
  • d_gosbell's avatar
    d_gosbell
    7 years ago

    Measures and columns are two different things, but if you are talking about doing this in a calculated column, then you could use the Substitute function

     

    eg

     

    SUBSTITUTE( [Column1] , "Oceania", "", 1)

2 Replies

  • d_gosbell's avatar
    d_gosbell
    Super User
    7 years ago

    Measures and columns are two different things, but if you are talking about doing this in a calculated column, then you could use the Substitute function

     

    eg

     

    SUBSTITUTE( [Column1] , "Oceania", "", 1)