Forum Discussion

CetinT's avatar
CetinT
Frequent Visitor
2 years ago
Solved

Using LEN in LEFT

Hi Everbody, I want to count the characters in a column, subtract a certain number of characters from this number and then shorten it. But it gives an error. Below is the DAX code I use. Is it pos...
  • Dangar332's avatar
    Dangar332
    2 years ago

    Hi, CetinT 

    CetinT 

    create new calculated column

    Column = LEFT('Table'[W_HOUSE],LEN('Table'[W_HOUSE])-2)

     

    or YOU can create measure 

    Measure = MAXX('Table',LEFT('Table'[W_HOUSE],LEN('Table'[W_HOUSE])-2))

     

     

CetinT's avatar
CetinT
Frequent Visitor
2 years ago

Thanks for your suggestion. But due to the regional settings of my computer I have to use ( ; ).

Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

Hi, CetinT 

provide some sample data

 

  • CetinT's avatar
    CetinT
    Frequent Visitor
    2 years ago

    You can find sample data below. I want to cut the last two characters.

     

    W_HOUSERESULT
    DOR00401DOR004
    TIRDOR00501TIRDOR005
    FDOR00601FDOR006
    • Dangar332's avatar
      Dangar332
      Resident Rockstar
      2 years ago

      Hi, CetinT 

      CetinT 

      create new calculated column

      Column = LEFT('Table'[W_HOUSE],LEN('Table'[W_HOUSE])-2)

       

      or YOU can create measure 

      Measure = MAXX('Table',LEFT('Table'[W_HOUSE],LEN('Table'[W_HOUSE])-2))