Forum Discussion

ilcaa722's avatar
ilcaa722
Frequent Visitor
2 years ago

return text from list

i have a table in PQ. 2 columns, 'Month" and "Year". there are only 2 entries i want to retreive them and make a string   my PQ table Month, Year August, 2023   output as a string= August_2023 ...
Need Help
ronrsnfld's avatar
ronrsnfld
Super User
2 years ago

Use the Add Custom Column wizard.

  • ilcaa722's avatar
    ilcaa722
    Frequent Visitor
    2 years ago

    ? not sure I follow. how would adding a column generate a string value using the 2 fields in my table?

    • ronrsnfld's avatar
      ronrsnfld
      Super User
      2 years ago

      When you select that wizard, a window will open which prompts you to add a formula. Merely concatenate the two columns. eg =[Month] & "_" & Text.From([Year])