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

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))