Forum Discussion
jerryr125
Helper IV
Helper IVCalculating the current week number - starting with the previous Saturday
Hi - I presently have a calculation in my Power Query application for the Week Number: Date.WeekOfYear([ABCDate], Day.Monday) I would like to Week Number to start from the previous Saturday ...
Yes, exactly such easy and you can also replace Day.Saturday by number and rewrite it as
Date.WeekOfYear([ABCDate], 6)
Omid_Motamedise
Super User
Super UserYes, exactly such easy and you can also replace Day.Saturday by number and rewrite it as
Date.WeekOfYear([ABCDate], 6)
jerryr125Helper IV
Helper IVthank you !!