Forum Discussion
NickProp28
5 years agoPost Partisan
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
NickProp28 , For the only S, the filter should be like
LEFT(TABLE[JOBNUMBER],1)="S")
You can use Search
1 Reply
- amitchandakSuper User
NickProp28 , For the only S, the filter should be like
LEFT(TABLE[JOBNUMBER],1)="S")
You can use Search