Forum Discussion

Simon_Br's avatar
Simon_Br
Icon for Helper I rankHelper I
3 years ago
Solved

Text.End Variable Value

Hello Comunity,   Actaul i have the challange, an value to split whit a dynamic value in the M-Code in Power Query.   Per Example:   Text Length Number Solution America30 2 30 Au...
Tips and Tricks
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi Simon,

     

    This should work fine in a new custom column:

     

    Text.End([Text], [Length Number])

     

     

     

    Pete

Simon_Br's avatar
Simon_Br
Icon for Helper I rankHelper I
3 years ago

Thank for the answer.

And whit the length? ... each Text.End(_, value(length number),...