Error with parameter data type

[Jonete]

Hello eveybody and Happy Christmas:

I'm very new in Report Builder and i'm unable to create a new dataset based on a parameter.

I have this simple DAX:

DEFINE
VAR UltMesCerrado=value(@UltMes)
EVALUATE

SUMMARIZECOLUMNS(
'Calendario'[Año],
'Calendario'[Mes],     // This is the month number
'Calendario'[MesTexto],
FILTER(Calendario, 'Calendario'[Mes] = UltMesCerrado),
"Gastos", 'AA_Medidas'[Gastos]))

But when i run it I get a message saying that [Calendario].[Mes].[4] cant't be converted from text to number.

[Calendario].[Mes].[4] is the default value of the parameter, which is defined as integer in the parametes section.

Any help would be much apreciated. Thanks in advance.

Jon Marquet

[v-deddai1-msft · Accepted solution]

Hi @Jonete ,

I suggest you use Value function in your formula to cobvert text value to number value.

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

Best Regards,

Dedmon Dai

[lbendlin]

What is your reason for including the calendar month in the SUMMARIZECOLUMNS() call when you also filter by it? Seems redundant.

Have you tried using Number.From('Calendario'[Mes]) in the filter?