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