Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
36
Views
Topic starter
Hello Team,
I have a column with date list I want to convert the date column where day will be 01 however month and Year to be picked from the date column.
We can do this in excel using this formula =DATE(YEAR(A2),MONTH(A2),1) where A2 is the invoice date. I am struggling to do this in Power query.
Regards
Santosh
| Invoice Date | My Required Date |
| 1/10/2021 | 1/1/2021 |
| 1/20/2021 | 1/1/2021 |
| 1/22/2021 | 1/1/2021 |
| 2/23/2021 | 2/1/2021 |
| 2/11/2021 | 2/1/2021 |
Posted : 28/01/2021 12:30 pm
Hi Santosh,
Split the Invoice Date column by delimiter. Then add a Custom Column:
=#date([year],[month],1)
Replace Year and Month with your column names for those fields.
Mynda
Posted : 28/01/2021 8:40 pm
