DAX error

[miftah_02]

Hi All

I'm trying to use this function ...

_Gr_Numeric = CONVERT(LEFT(TExportDataMS_Daily[_Gr],LEN(TExportDataMS_Daily[_Gr])-1),INTEGER)

but I just get this error message bellow:

 An argument of function 'LEFT' has the wrong data type or has an invalid value

And also I'm trying to use this function

_MT = (TExportDataMS_Daily[Sales Qty]*TExportDataMS_Daily[_Gr_Numeric])/10^6

And i get this error message bellow:
This expression refers to a Column Object named 'TExportDataMS_Daily[_Gr_Numeric])', which has an error.

Can anyone help?

Thanks in advance!

[amitchandak]

@miftah_02 , see fine may be a data type issue

Try like

Gr_Numeric = LEFT(TExportDataMS_Daily[_Gr]&"",LEN(TExportDataMS_Daily[_Gr]&"")-1)*1

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[miftah_02]

Thank you for the answer, i try but is not working

i have Gr clumn like this

And I want to make Gr numeric, but the syntax erorr like this