Convert a list of months (numbers) to month names

[Gerardo]

Hello,

How can I convert the result of this expression to the name of the month? Currently it gives me a list of months "1,2,4,5,7", I want to do this like this "January-February-April-May-July".

-----------------------------------------------

if(
AND(
[mes]<=MONTH(TODAY()),
[becado]="No",
[status]="Activo"
),
SELECT(
Meses[mes],
AND(
year([fecha ingreso])<=YEAR(TODAY()),
[mes]>=month([fecha ingreso]),
[mes]<=MONTH(TODAY())

)
)
-
SELECT(
registro pagos[mes a pagar],
AND(
[_thisrow].[id alumno]=[nombre],
[mes a pagar]>=[mes],
[tipo pago]="mensualidad",
[año]=YEAR(TODAY())
)
),
SELECT(
Meses[mes],
AND(
year([fecha ingreso])<=YEAR(TODAY()),
[mes]<=month([fecha ingreso]),
[mes]<=MONTH(TODAY())

)
)
-
SELECT(
registro pagos[mes a pagar],
AND(
[_thisrow].[id alumno]=[nombre],
[mes a pagar]<=[mes],
[tipo pago]="mensualidad",
[año]=YEAR(TODAY())
)
)
)

---------------------------------------------

Thanks for your support

[Joseph_Seddik · Accepted solution]

Add a new "nombreMes" column to your Meses tables, use SELECT() on this column instead of "mes", while keeping "mes" in the calculations inside each SELECT().

[Gerardo]

Thanks a lot