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?
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.