Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to extract continuous string set from a column with multiple criteria

Hi, I have a Column A with client names. Table 1                                                                      Table 2 Client Name                                                         ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous - OK, I updated this with a Client Name output version and Project output version in 2 additional columns. I checked the matches, don't see anything obviously amiss. Solved?

     

    PBIX is attached. 

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous - I will take a look.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous - OK, I updated this with a Client Name output version and Project output version in 2 additional columns. I checked the matches, don't see anything obviously amiss. Solved?

 

PBIX is attached. 

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    Anonymous Glad we got there, was an interesting problem. There are still replies in this thread you haven't kudo'd... 🙂

     

    This may be my record for longest thread before solution, 6 pages!!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Greg_DecklerGenius!! Thank you so much for this. You have literally spared me a grave headache. Wish I could give you a dozen Kudos haha!! Peace!

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    4 years ago

    Hi Greg, pleasure in greeting you... 2 queries:

    1. Does the Microsoft Power BI Cookcbook (2nd Edition) have a Spanish version?

    2. In the book, will you have cases to identify ranges of text and texts with momodines?

    Example, if I have the value "AC23", "AJ80" and "KRZ600".

    NumberSinceUntil
    Caso1AB01AJ70
    Caso2A*J*
    Caso3KRZ600

    AC23 = Case1 and Case2

    AJ80 = Caso2

    KRZ600 = Caso3

    Thanks and greetings...