Forum Discussion

NickProp28's avatar
NickProp28
Post Partisan
5 years ago
Solved

LIKE SQL in DAX

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