Sometimes it’s the little things that can help you minimize the number of steps in your Power Queries.
Here is another example that might help you.
Let’s imagine your data contains two columns with year and the month name and you want to create a date column.
Start by selecting both columns and under the Add Column tab select Merge Columns
Specify the separator as a space and give your column a name (to avoid a rename column step )
This will result in a step
Now modify the step to
And then in one step you have a date column – as I have a Danish format in the format is DD-MM-YYYY.
Happy Querying
Pingback: Creating a Date Column in Power Query from Year Number and Month Name – Curated SQL