Expression.Error: We cannot convert the value "2012" to type Number.

[isha88sheth]

Getting Expression.Error: We cannot convert the value "2012" to type Number. when using this function for a custom column:

      Text Year = Text.Combine({[Quarter Begin Month],"/", Number.ToText([Year])})

Year - Whole Number format, values e.g. 2012, 2013, 2014

Quarter Begin month - Text format

Text Year - Text format

Why is the function trying to convert [Year] to Number when I have used Number.ToText function?

Appreciate any help

.

[Vvelarde]

@isha88sheth

Hi, Reviewing your filter options i saw the year column is already Text Type.

Don't need to transform to text.

Regards

Victor

[isha88sheth]

Must have taken the screenshot while playing around with format type.

Getting the same error with Year foramtted as Whole Number...