Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Shawry
Helper I
Helper I

How to calculate week ending

Hi, 

I have a Week Ending formula to calculate the week ending date (ending on a Sunday). However, I've come across a problem when dealing with a Sunday. You'll see in my table that when the row is in fact a Sunday, it includes that in the following week. 

For example, you'll see that the 5th of March (which is a Sunday) is included in the following week i.e. Week Ending = 12th Sunday. 

Does anyone know how I would resolve this? 

Thanks!

 

Shawry_0-1678329420008.png

 

 

1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

g

week Ending=[Date]-WEEKDAY([Date],2)+7

View solution in original post

2 REPLIES 2
Ahmedx
Super User
Super User

g

week Ending=[Date]-WEEKDAY([Date],2)+7

Thank you 🙂

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.