Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Can't subtract

I  just want the characters to the right of the word Breaker in one column (variable number to the left). If there is an easier way, let me know. I got close, but I want to subtract 7 from the numbe...
Need Help
  • CoreyP's avatar
    CoreyP
    2 years ago

    Oh, yeah. Way easier in Power Query. Just split column by delimiter, custom delimiter, " breaker "

vicky_'s avatar
vicky_
Icon for Super User rankSuper User
2 years ago

Characters to Right = RIGHT('Table'[Column1], LEN('Table'[Column1]) - FIND("Breaker ", 'Table'[Column1], 1, 1) - 7)

You can use the FIND or SEARCH functions to find the "Breaker" keyword instead of using the char column (but both should still work fine). 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Sorry, should have added what Char is 

    Char = len('Maximo Data'[description])-(SEARCH("breaker",'Maximo Data'[description],1,blank()))
    When I make it this, it throws an error in the GE_Sec_dis column. 
    Char = len('Maximo Data'[description])-(SEARCH("breaker",'Maximo Data'[description],1,blank()))-7
     
    When I tried to make it all one formula, it threw error. I thought it was the search and len together, but looks like it was the -7 part. 
     
    If I try adding another column, char2 = 'Maximo Data'[Char]-7
    and changing reference to char2,  
    GE_sec_dis = if(and('Maximo Data'[manufacturer]="GENERAL ELECTRIC", 'Maximo Data'[classstructure_classificationid]="CB"), right('Maximo Data'[description], 'Maximo Data'[char2]),blank())
    I get this error