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?
Hello,
Unfortunately that did not work. It is still showing as error.
grantsamborn
Solution Sage
Solution SageIs it still the same error?
Did you do the replacement in both places?
Is Query[Month_Number] numeric?
Yes, I added to both places and Query[Month_Number] is numeric (1.2).
- grantsamborn
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.
I copied your exact DAX - however it still is showing error although it works on your end.
- grantsamborn
This seems like it could be handled with a date table with [Fiscal Year] and [Fiscal Period] calculated for each [Date] ahead of time.
Date Dimension Setup using M script.docx