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 - 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. 

 

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...