Skip to main content
cancel
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.

Reply
ilcaa722
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

 

 

 

5 REPLIES 5
v-xinruzhu-msft
Community Support
Community Support

Hi @ilcaa722 

You can add a custom column

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

vxinruzhumsft_0-1695696976837.png

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

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

Announcements
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

PBI_APRIL_CAROUSEL1

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