March 21, 2019
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.
|Invoice Date||My Required Date|