Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I am able to get the Work Week results by using "=Date.WeekOfYear([My Data])". However i am tyring to figure out how can i get the Work Week to start on Sunday's at 6:00:00AM and end on Sunday's at 5:59:59AM.
Example:
If my data is "8/27/2023 5:59:00", i would like the results to be 34 (WW34)
and
If my data is "8/27/2023 6:01:00", i would like the results to be 35 (WW35)
I'm sorry if this is a simple task but i've trying to search and cant find anything on this type of case.
Thanks in advance.
Solved! Go to Solution.
Simple enough
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
Simple enough
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
@ThxAlot , This worked perfectly. Thank you so much.
Last question for learning purposes, does (0,6,0,0) represent (Days, Hours, Minutes, Seconds)?