Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
In my Date (or calendar) table I need a column having the week ending dates on Friday.
Similar to Excel:
https://excel.tips.net/T002444_Calculating_Week-Ending_Dates.html
If someone has previously solved/pls share link.
Solved! Go to Solution.
I have used this formula before and it worked for me
Weekend = 'Calendar'[DT]-MOD('Calendar'[DT]-1,7)+5
The weekending calculations here are WRONG!
I wanted to get a weekending of Friday. So for me my week was from Sat 00:00 to Fri 23:59. This is the RIGHT formula for it
Week_Ending6 = [creation_date] - MOD([creation_date]+0|7)+6
I have used this formula before and it worked for me
Weekend = 'Calendar'[DT]-MOD('Calendar'[DT]-1,7)+5
I used your formula to calculate my week ending for Thursdays, however in some cases the week ending date is before the completion date:
MG_WeekEnding = 'MG_WIP'[CompletionDate]-MOD('MG_WIP'[CompletionDate]-1,7)+4
HI There,
I played around with dummy data and i found this:
If completion date is Friday, with this formula week ending will be last thursday. I think you need to decide if you want to roll over Friday to next week or the current actual week
I have used this to calculate my week ending on Thursdays, however sometimes the calculated week ending date is before the completion date:
MG_WeekEnding = 'MG_WIP'[CompletionDate]-MOD('MG_WIP'[CompletionDate]-1,7)+4
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
82 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
111 | |
110 | |
72 | |
71 |