Mont name in spanish - Measure

[Jonete]

Hello everybody:

I`m newBIe and i can´t get this issue resolved.

I would like to show in my report the month data belong, and I use:

Z_TituloMes2 = "Control Presupuestario  " & format(max(Datos[FechaConta]);"mmmm")

Where [FechaConta] is the date 

This works fine, but i would like the month name to be in spanish. Is it possible?

Thank you very much.

[v-ljerr-msft · Accepted solution]

Hi @Jonete,

In this scenario, I would suggest you to translate the month name to Spanish by adding a new custom column in Query Editor using Date.MonthName function(M) where you can specify the language for the month name in the second argument first.

Then you should be able to use the formula below to show the month name in Spanish.

Z_TituloMes2 =
VAR maxFechaConta =
    MAX ( Datos[FechaConta] )
RETURN
    "Control Presupuestario  "
        & CALCULATE (
            FIRSTNONBLANK ( Datos[SpanishMonthName]; 1 );
            Datos[FechaConta] = maxFechaConta
        )

Regards

[Jonete]

Thank you very much. It Works fine.

[Jonete]

Hello everybody:

I`m newBIe and i can´t get this issue resolved.

I would like to show in my report the month data belong, and I use:

Z_TituloMes2 = "Control Presupuestario  " & format(max(Datos[FechaConta]);"mmmm")

Where [FechaConta] is the date 

This works fine, but i would like the month name to be in spanish. Is it possible?

Thank you very much.

[tjd]

Have you tried changing your regional options (File|Options and settings|Options|Current File|Regional Settings) to Spanish (xxx)?

[Jonete]

Thank you.

I tried your solution, but the month is still in english.

I'll keep trying.

[tjd]

OK, then what you should do is to create your own date table as described here.  Not at the top of the example that you have the ability to set the table's "Culture".  You just need to search for the proper spanish culture code.  For example, US English would be en-us.  You can find the culture code's here.