topic Re: Using LEN in LEFT in DAX Commands and Tips

Using LEN in LEFT

CetinT — Thu, 02 Nov 2023 07:46:15 GMT

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)

Re: Using LEN in LEFT

Dangar332 — Thu, 02 Nov 2023 08:30:43 GMT

HI, CetinT

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

use ( , ) instead of ( ; )

Re: Using LEN in LEFT

CetinT — Thu, 02 Nov 2023 08:34:00 GMT

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

Re: Using LEN in LEFT

Dangar332 — Thu, 02 Nov 2023 08:36:57 GMT

Hi, CetinT

provide some sample data

Re: Using LEN in LEFT

CetinT — Thu, 02 Nov 2023 08:52:36 GMT

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

W_HOUSE	RESULT
DOR00401	DOR004
TIRDOR00501	TIRDOR005
FDOR00601	FDOR006

Re: Using LEN in LEFT

Dangar332 — Thu, 02 Nov 2023 09:03:20 GMT

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