The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |