Función MID

Hola comunidad, Estoy tratando de crear esta formula que tengo en excel al Power BI =VALUE ( MID ( W2 , SEARCH ( "Horas de participación" , W2 ) + 26 , SEARCH ( ";Evaluación global", W2 ) - SEAR...

Need Help

Anonymous

1 year ago

Hi, Tesy

You can try the following methods.

Horas = 
VAR HorasPos = IFERROR(SEARCH("Horas de participación", 'Table'[COLUMNNAME]), 0)
VAR EvalPos = IFERROR(SEARCH(";Evaluación global", 'Table'[COLUMNNAME]), 0)
VAR IsPatternFound = (HorasPos > 0) && (EvalPos > HorasPos + 26)
VAR ExtractedText = 
    IF(
        IsPatternFound,
        MID('Table'[COLUMNNAME], HorasPos + 26, EvalPos - (HorasPos + 26)),
        BLANK()
    )
RETURN
    IF(IsPatternFound, VALUE(ExtractedText), BLANK())

Is this the result you expected?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Función MID.pbix19 KB

ryan_mayu

Super User

1 year ago

Tesy

you can try to create a column

=MID ( [COLUMNNAME], SEARCH ( "Horas de participación" , [COLUMNNAME]) + 26 , SEARCH ( ";Evaluación global", [COLUMNNAME]) - SEARCH ("Horas de participación" , [COLUMNNAME]) - 26 )

if this does not work, pls provide the error message or provide some sample data and expected output