Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
241
Views
Topic starter
Hi All:
I need to create a Custom Weekly Period 445 Calendar with Power Query starting on Feb 3, 2020 through Jan 31,2021.
Is there M code or an efficient way to create other than 52 conditional columns.
See Period Weekly (Fiscal or Accounting calendar breakout picture)
Thanks
Robb
Posted : 15/10/2020 3:41 pm
Hi Robb,
Create another table with the week start dates and week numbers, then merge that table with your data table to bring in the corresponding week numbers. A bit like doing a VLOOKUP in Power Query to a calendar table, except you're using Merge.
Follow the link for more instructions.
Mynda
Posted : 15/10/2020 6:37 pm
