Forum Discussion

athomp15's avatar
athomp15
Helper I
6 years ago
Solved

Append to string based on number (loop)

Hi,    Any help would be appreciated.  I have a source table that shows allocated resources on a project. I would like to add a new column which appends to the "Resource Allocated" column ";Anothe...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    6 years ago

    You can do this with a custom column that repeats ";Another" according to the missing amount:

     

    [Resources Allocated] & Text.Repeat(";Another", [Resources Missing])

     

AlexisOlson's avatar
AlexisOlson
Super User
6 years ago

You can do this with a custom column that repeats ";Another" according to the missing amount:

 

[Resources Allocated] & Text.Repeat(";Another", [Resources Missing])