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
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!
Solved! Go to Solution.
g
week Ending=[Date]-WEEKDAY([Date],2)+7
Thank you 🙂
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
108 | |
102 | |
94 | |
71 |
User | Count |
---|---|
173 | |
134 | |
132 | |
102 | |
95 |