Forum Discussion
Solved
Add date column in Power Query
Hi everybody, I have two columns in my table: ReportingYear ReportingPeriod Is is possible to add a custom column to combine the two to show an actual date? The day can be the first of the ...
Hi lekkerbek ,
Plese try the below:
- Add a custom column with value all 1 as Date.
- Then you can select all 3 columns and merge. Give separator as "-"
- Then change this Merged column to Date type.
Thank you!
In case it answered your question, please accept it as a solution.
Appreciate Your Kudos.
Hi lekkerbek ,
Plese try the below:
- Add a custom column with value all 1 as Date.
- Then you can select all 3 columns and merge. Give separator as "-"
- Then change this Merged column to Date type.
Thank you!
In case it answered your question, please accept it as a solution.
Appreciate Your Kudos.
Why do I always overcomplicate things.
Thank you. You are a star!