Fecha en español con formato mmm-yy convertirla a fecha

[AntoPasq]

Hola! Tengo la siguiente tabla:

La fecha está en español con formato mmm-yy y no lo reconoce para pasar a formato fecha. Cuál es la forma más simple convertir esto a fecha?

[v-yiruan-msft · Accepted solution]

Hi @AntoPasq ,

You can create a calculated column as below to get it, please find the details in the attachment.

DateEN =
VAR DayOfTheDate = 1
VAR YearOfTheDate =
    VALUE ( RIGHT ( 'Table'[Mes], 2 ) )
VAR MidPortion =
    LEFT ( 'Table'[Mes], 3 )
VAR MonthOfTheDate =
    SWITCH (
        TRUE (),
        MidPortion = "Ene", 1,
        MidPortion = "Feb", 2,
        MidPortion = "Mar", 3,
        MidPortion = "Abr", 4,
        MidPortion = "May", 5,
        MidPortion = "Jun", 6,
        MidPortion = "Jul", 7,
        MidPortion = "Ago", 8,
        MidPortion = "Sep", 9,
        MidPortion = "Oct", 10,
        MidPortion = "Nov", 11,
        MidPortion = "Dic", 12,
        0
    )
RETURN
    DATE ( 2000 + YearOfTheDate, MonthOfTheDate, DayOfTheDate )

Best Regards