Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Change and output string value in a table

Hi all,   Is there away to trim or change a string from an array and only output particular terms.   For example, from the table below, I only want to output the string values of 'Owners' and 'Me...
"DAX"
DAX ALL PowerBI Excel
Ajendra's avatar
Ajendra
Icon for Resolver I rankResolver I
3 years ago

Hey,

 

Try this one!

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks Ajendra, Struggling abit with the walk through.

     

    So copy and renamed the table, in your example to "Help Column"
    When I add the second line it's not autopopulating?

    Cheers!



    • FreemanZ's avatar
      FreemanZ
      Icon for Super User rankSuper User
      3 years ago

      hi Anonymous 

      the suggested solutions are DAX code and supposed to add calculated columns, instead of custom column in Power Query.