Forum Discussion
Solved
Extract text before delimiter in fabric using DAX.
Hey All, I have a column that is ticket numbers like SCTASK0012345, WKR0012345 etc. I need to extract all the text before the numbers to create a column for "Ticket Type". This data set comes fro...
Hi,
Try something like below whether it suits your requirement.
It is for creating a calculated column.
TicketType = LEFT ( query1[Number], SEARCH ( 0, query1[Number] ) - 1 )
Jihwan_Kim
Super User
Super UserHi,
Try something like below whether it suits your requirement.
It is for creating a calculated column.
TicketType =
LEFT ( query1[Number], SEARCH ( 0, query1[Number] ) - 1 )