Trim the first 7 characters from value

[Anonymous]

I'm using direct query to trim the first 7 characters from a column that contain the character "/" e.g.  Period 1 2018/2019

This is what I have come up with so far however it keeps giving me an error that ISERROR cannot be recognized for DAX expressions around Direct Query, is there another way around this?

CustomColumn = IF(ISERROR(SEARCH("/", 'looker_views lkr_Questionnaire'[Questionnaire_Title_Secondary])

    ),

    "/",

    LEFT('looker_views lkr_Questionnaire'[Questionnaire_Title_Secondary], 7)

)

[v-kelly-msft · Accepted solution]

Hi @Anonymous，

Try to modify your measure as below:

CustomColumn = IF((SEARCH("/", 'looker_views lkr_Questionnaire'[Questionnaire_Title_Secondary],,BLANK())=BLANK()
    ,
    "/",
    LEFT('looker_views lkr_Questionnaire'[Questionnaire_Title_Secondary], 7)
)

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Anonymous , there quite a few restrictions what you can do in direct query terms of column

refer few at the end. You have to change it

https://radacad.com/directquery-connection-in-power-bi-how-does-it-work-limitations-and-advantages

What you are trying to achieve here