Extraer numero de texto

Anonymous,

You can write an IF ( ) with an ISERROR to only show when there is no error.

Column = 
IF (
    NOT (
        ISERROR (
            VALUE (
                RIGHT ( Table1[Column1], 2 )
            )
        )
    ),
    VALUE (
        RIGHT ( Table1[Column1], 2 )
    )
)

Excellent!!!!
Thank you very much for your help. Can I take advantage and ask about a formula to calculate the growth rate?

Hola,

En power query intenta:

1-Transforma la columna a Texto (temporalmente)

2-En el Menu>Transform (o Add Column en caso ocupes una columna extra)>Extract  (aqui seleciona los ultimos 2 characteres)

3-Cambiar el formato de las columnas de Texto a Numero

Anonymous,

You should start another Post as it is not related to this Post.  You should make sure to include sample data that is relevant to your issue.