topic Re: Error with parameter data type in Report Server

Error with parameter data type

Jonete — Wed, 23 Dec 2020 10:43:36 GMT

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

Re: Error with parameter data type

lbendlin — Thu, 24 Dec 2020 00:10:27 GMT

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?

Re: Error with parameter data type

v-deddai1-msft — Fri, 01 Jan 2021 06:38:31 GMT

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