Solved: Calculating the current week number - starting wit...

jerryr125 · ‎10-08-2024

Hi - I presently have a calculation in my Power Query application for the Week Number:

Date.WeekOfYear([ABCDate], Day.Monday)

I would like to Week Number to start from the previous Saturday to the Current Week Friday.

Example:

Week #42 would be from Saturday, October 12th to Friday October 18th

If ABCDate is within that range, it would have a value of "42"

Is it as simple as :

Date.WeekOfYear([ABCDate], Day.Saturday)

Thoughts ? Jerry

Omid_Motamedise · ‎10-08-2024

Yes, exactly such easy and you can also replace Day.Saturday by number and rewrite it as

Date.WeekOfYear([ABCDate], 6)

If my answer helped solve your issue, please consider marking it as the accepted solution. It helps others in the community find answers faster—and keeps the community growing stronger!
You can also check out my YouTube channel for tutorials, tips, and real-world solutions in Power Query with the following link
https://youtube.com/@omidbi?si=96Bo-ZsSwOx0Z36h

View solution in original post

Anonymous · ‎10-10-2024

Hi @jerryr125

Did the solution @Omid_Motamedise and @Greg_Deckler offered help you solve the problem, if it helps ,you can consider to accept them as solutions so that more user can refer to.

Best Regards!

Yolo Zhu

Omid_Motamedise · ‎10-08-2024

Yes, exactly such easy and you can also replace Day.Saturday by number and rewrite it as

Date.WeekOfYear([ABCDate], 6)

If my answer helped solve your issue, please consider marking it as the accepted solution. It helps others in the community find answers faster—and keeps the community growing stronger!
You can also check out my YouTube channel for tutorials, tips, and real-world solutions in Power Query with the following link
https://youtube.com/@omidbi?si=96Bo-ZsSwOx0Z36h

jerryr125 · ‎10-11-2024

thank you !!

Greg_Deckler · ‎10-08-2024

@jerryr125 Yes, that should be how to do it.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...