Forum Discussion
Cannot convert value '' of type Text to type Number.
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?
grantsamborn
Solution Sage
Solution SageNot 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.
I copied your exact DAX - however it still is showing error although it works on your end.
My fiscal year Column is "F22, F23,..." Not 2022, 2023 which I cannot convert to number.
- grantsamborn
My guess is you have an invalid value for [Fiscal Year] .
I would start by looking for a blank row.