topic Re: Error MdxScritp(Model)(155,63) > Cannot convert value "-" of type Text to type Numeric/Date in DAX Commands and Tips

Error MdxScritp(Model)(155,63) > Cannot convert value "-" of type Text to type Numeric/Date

NickzNickz — Tue, 04 Jul 2023 11:07:53 GMT

Hi ..

I have below testing measures and can view the result...

Migration (RM) = VAR _Result = CALCULATE( SUM( fin_migration[Migration (M)] ), fin_migration[Date] = MAX( fin_migration[Date] ), fin_migration[Month] = MAX( fin_migration[Month] ) ) RETURN IF(ISBLANK(_Result),"0.00",_Result)

However, when I try to change from "0.00" to "-" , I received an error as below:

MdxScritp(Model)(155,63) > Cannot convert value "-" of type Text to type Numeric/Date

What should I do next to resolve the problem? ...

Regards,

NickzNickz

Re: Error MdxScritp(Model)(155,63) > Cannot convert value "-" of type Text to type Numeric/Date

johnt75 — Tue, 04 Jul 2023 12:54:36 GMT

A measure can only return values of a single type, so everything will need to be numeric or everything will need to be text. If you want to return the values as text you could use the FORMAT function, otherwise you'll need to keep the measure returning blank or 0 when the result is blank.

Re: Error MdxScritp(Model)(155,63) > Cannot convert value "-" of type Text to type Numeric/Date

NickzNickz — Thu, 06 Jul 2023 02:41:44 GMT

Hi johnt75 ,

Both my measure and tables are in decimal numbers.

Other tables were just okay... No problem. ..

Regards,

NickzNickz