Using LEN in LEFT

[CetinT]

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 possible for you to help?

LEFT(SALES[W_HOUSE]; LEN(SALES[W_HOUSE])-2)

[Dangar332]

HI, @CetinT 

LEFT(SALES[W_HOUSE], LEN(SALES[W_HOUSE])-2)

use ( , )  instead of  ( ; )

[CetinT]

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

[Dangar332]

Hi, @CetinT 

provide some sample data

[CetinT]

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

W_HOUSE	RESULT
DOR00401	DOR004
TIRDOR00501	TIRDOR005
FDOR00601	FDOR006

[Dangar332 · Accepted solution]

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