Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

dax help with substrings

Hi,

 

I have a column which has values such as 

OGC, REGION, WB, FB, HCPB,  REGSUNIT

. 

How can write a formula in DAX so that I can extract the substrings?

 

Example - if I need to extract 'WB' from the above string? The string that I need to extract will depend on another condition.

 

Thanks,

 

Need Help

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous you can use containsstring function to check if your search string exists in the column and go from there.