Forum Discussion
NickProp28
Post Partisan
5 years agoLIKE 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 rep...
- 5 years ago
NickProp28 , For the only S, the filter should be like
LEFT(TABLE[JOBNUMBER],1)="S")
You can use Search
amitchandak
Super User
5 years agoNickProp28 , For the only S, the filter should be like
LEFT(TABLE[JOBNUMBER],1)="S")
You can use Search