Date field for power query M

[Anonymous]

Want to create a date field which goes back 10 weeks + current/ ongoing week in Power Query M

Want to create this dynamic field but facing issue creating the field.

[amitchandak]

@Anonymous , you can create a column like

Date.AddWeeks( DateTime.Date(DateTime.LocalNow()), -10)

You can now get weekstartdate using Date.StartOfWeek

refer if needed

https://medium.com/@amitchandak/cheat-sheet-power-query-financial-year-calendar-5ceaacb520f1