Filter by delimiter

[JamesGordon]

Hi,

I am trying to create a DAX to filter a column of Stock Numbers. The Stock Numbers in the column are in a format

"Wg No : 61034599"

All i am after is the 61034599 - am i best to filter by a delimiter or by another function? So far i have been unable to create a DAX that will present just the 61034599

Is someone able to suggest a suitable DAX?

Thanks in Advance!

[ahmedoye]

@JamesGordon You can equally write a measure using the CONTAINSTRING Function.

For Example, 

CALCULATE(SUM(ATable[Column]),FILTER(ATable,CONTAINSSTRING(ATable[AnotherColumn], 61034599)))

If this solution works for you, You can also mark it to allow others benefit from it.

[az38 · Accepted solution]

Hi @JamesGordon 

try a column

Column = MID([Stock Numbers],SEARCH(":",[Stock Numbers])+2,LEN([Stock Numbers])-SEARCH(":",[Stock Numbers]))