Forum Discussion
Cannot convert value '' of type Text to type Number.
Hi, Anonymous ;
Because format([date],"YY'") becomes text format. It is no longer possible to calculate, for example, in 2021, it will become "21" after format, and the format is text format *1-1 and cannot be calculated. So you can change to the following dax.
FY = IF ( MONTH ( dim_mo[mo_date] ) >= 9, FORMAT ( dim_mo[mo_date], "YY" ) & "/" & RIGHT ( YEAR ( dim_mo[mo_date] ) + 1, 2 ), RIGHT ( YEAR ( dim_mo[mo_date] ) - 1, 2 ) & "/" & FORMAT ( dim_mo[mo_date], "YY" ) )
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.yes probaby you would need to handle your blanks by using an if statement something like
if(isblank(date), blank(), your conversion)
Community Championis your new column datatype text or a whole number?
what are you expecting?
It's a text. The output I am expecting is the same are you're getting so not quite sure why mind doesn't work. Thanks for checking
I have looked at the date field and can see I have (blanks) in there. Would that be what is causing this not to work?
- vanessafvg
yes probaby you would need to handle your blanks by using an if statement something like
if(isblank(date), blank(), your conversion)