Forum Discussion

PascalT's avatar
PascalT
Icon for Helper I rankHelper I
9 years ago
Solved

[DAX] isolate text from text

Dear PBI Experts   I guess that this is a very noby question... but i've a hard time to solve it.   In a column, I've several line structured like that: /products/coral-dental-33600002-17 /prod...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    Well, I'm not a DAX expert, but from my Excel background I constructed the following DAX formula.
    Prerequisite is that your strings don't contain any ^ character.

     

    =right([String],len([String])-find("^",substitute([String],"-","^",-1+len([String])-len(SUBSTITUTE([String],"-","")))))
PascalT's avatar
PascalT
Icon for Helper I rankHelper I
9 years ago

Hi again Marcel

 

Thank you.

I'll sort this out based on your formula. I'll have to change the [String] by the name of my colum containing the products. If I just replace this, it doesnt work but i'll try on my side and see if I succeed ;-)

By the way, do you have a good tutorial to recommend about DAX and PowerBI for "newbies" ?

 

Thank you all

 

Pascal