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

 

how can i accomplish

 

 

 

Need Help

5 Replies

    • 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])

  • Prachi_31's avatar
    Prachi_31
    Regular Visitor
    2 years ago

    Hi ilcaa722,

    You have to create custom column in power query using your month and year column.

    Just simply create custom column named month_year and add the following DAX in power query :
    month_year = [Month] & "_" & [Year]

    Regards,
    Prachi

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

     
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi ilcaa722 

    You can add a custom column

    Text.Combine({[Month],Text.From([Year])},"_")

    Best Regards!

    Yolo Zhu

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