Forum Discussion
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 rep...
NickProp28 , For the only S, the filter should be like
LEFT(TABLE[JOBNUMBER],1)="S")
You can use Search
NickProp28 , For the only S, the filter should be like
LEFT(TABLE[JOBNUMBER],1)="S")
You can use Search