Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

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




Community Support
Community Support

Hi @ilcaa722 

You can add a custom column



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.


Regular Visitor

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]


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.

Super User
Super User

Use the Add Custom Column wizard.

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

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

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors