Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |