Cannot convert value '' of type Text to type Number.

Question

Hello, I have create a calendar date to coincide with fiscal year. It was recently working and just broke with a new upload of monthly data. Wondering how to fix this?&nbsp;&nbsp;

grantsamborn · Answer

Hi&nbsp;Anonymous&nbsp;It appears you are using the result of RIGHT() (text type) as a number in the calculation.Try replacing:&nbsp; &nbsp; &nbsp;RIGHT( Query[Fiscal Year], 2)with:&nbsp; &nbsp; &nbsp;VALUE( RIGHT( Query[Fiscal Year], 2) )&nbsp;&nbsp;

anonymous · Answer

Hello,&nbsp;Unfortunately that did not work. It is still showing as error.

grantsamborn · Answer

Is it still the same error?Did you do the replacement in both places?Is Query[Month_Number] numeric?

anonymous · Answer

Yes, I added to both places and Query[Month_Number] is numeric (1.2).&nbsp;

grantsamborn · Answer

Not sure what it would be.Here is an example with [Month_Number] as a whole number and [Fiscal Year] as text, using your calculated column.Calendar Date problem.pbix&nbsp;

Forum Discussion

Cannot convert value '' of type Text to type Number.

9 Replies

Related content

Convert text to number

Convert Number to Date

Convert Text to number with DAX

Convert numbers to month

Convert numbers to Months