Forum Discussion

rpinxt's avatar
rpinxt
Icon for Solution Sage rankSolution Sage
4 years ago
Solved

Custom Column Formula Help

Ok so I made this Custom Colum in Query Editor: Now this works just fine however I have 1 extra requirement. So where it takes the first 2 characters of [Material] in 90% of the cases these a...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi rpinxt ,

     

    Please try this formula:

     

    if [Mat.Type]="ZRAW" then try Number.From(Text.Start([Material],2)) otherwise "LB" else "X"

     

    PS: I helped you move your post to the Power Query forum. Posting in the correct forum next time will help you solve the problem faster.

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
4 years ago

Sure, you can do it without adding the column.

Personally I divide and conquer when attacking a problem, it's easier to debug and separate out parts of the logic.

One thing about Power Query steps is that you can add columns to help, get other results and then remove the helper columns.

 

  • rpinxt's avatar
    rpinxt
    Icon for Solution Sage rankSolution Sage
    4 years ago

    I understand but in a large dataset would adding all these extra columns not lead to worse performance (and  I do understand that complex formulas would do the same but still)

     

    Also...how would that formula look 😊....because there does not seem to be an IFERROR formula othere then try / otherwise....but that would not fit very good in my if formulas.....