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

     

     

Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

HI, CetinT 

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

use ( , )  instead of  ( ; )

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