Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX error

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!

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , 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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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