LIKE SQL in DAX

[NickProp28]

Dear Community,

Would like to get help on one dax.

I have a column name 'JobNumber'. 

Job number have S job, B job and I job.

EXP: S0001234, B0003214, I0302133.

I only want S job in my report.

But i have tried this dax and still doesnt work for me.

...&& NOT(LEFT(TABLE[JOBNUMBER],1)="B") &&....

Thanks for your time and help on my issue

[amitchandak · Accepted solution]

@NickProp28 , For the only S, the filter should be like

LEFT(TABLE[JOBNUMBER],1)="S")

You can use Search

https://docs.microsoft.com/en-us/dax/search-function-dax