Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |