Forum Discussion
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 ...
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.