return text from list

[ilcaa722]

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

[Anonymous]

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.

[Prachi_31]

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.

[ronrsnfld]

Use the Add Custom Column wizard.

[ilcaa722]

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

[ronrsnfld]

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