Forum Discussion

IvanS's avatar
IvanS
Icon for Helper V rankHelper V
3 years ago
Solved

Extract text after specific text string

Hi guys,   I am trying to get location code from the column Subject in table FACT_Tasks - example below:   Logic: If Subject contains (anywhere) the specific text string (AAAA or BBBB), then - I...
Need Help
Tips and Tricks
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    you can change the numbers 10 and 12 to any other numbers if it is necessary for you

Ksyokz23's avatar
Ksyokz23
Frequent Visitor
2 years ago

Ahmedx How about if I want to do same but this time with Power Query not with DAX 

IvanS's avatar
IvanS
Icon for Helper V rankHelper V
2 years ago

Hi Ksyokz23 ,

check the response from ThxAlot in this thread. 

 

  • Ksyokz23's avatar
    Ksyokz23
    Frequent Visitor
    2 years ago

    IvanS It worked thank you