Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
769
Views
Topic starter
Hi team,
I just want to add dates for each month, instead of start of month date for 12 months for the year.
I am referring to 7.08 add or expand row of the power query. please see attached.
Please let me know custom formula for that.
Thank you.
Regards,
Aye
Posted : 19/02/2019 6:49 am
Hi Aye,
Presumably you know the date you want to add because it's somewhere in your data already, just not in the correct format? If so, please provide a sample Excel file with your data so we can help you with a specific answer.
Mynda
Posted : 19/02/2019 7:38 pm
Hi Aye,
This appears to be a duplicate question. I've answered it here: https://www.myonlinetraininghub.com/excel-forum/power-query-members/dates-and-cross-calculation-between-sheets#p8260
Mynda
Posted : 19/02/2019 8:39 pm