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)