cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tuan
Helper III
Helper III

Calculating Sales Per Week (Partial)

I'm trying to calculate Sales Per Week. The problem i'm having is the Partial weeks since im using a Regular Calendar Year.

 

Since there are only 2 days in week 27 for June, I was trying to get the June month to use 4.28 as the denominator instead of 5.

I've been wracking my brain on how to calculate this.

 

My Data is as follows.

Tuan_0-1593299688182.png

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Tuan , You can try divide by distinct count of date

divide(sum(Table[New Sales]),distinctcount(Table[Sales Date]))

 

Prefer to Date table and have Week there

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Tuan , You can try divide by distinct count of date

divide(sum(Table[New Sales]),distinctcount(Table[Sales Date]))

 

Prefer to Date table and have Week there

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

mahoneypat
Super User
Super User

Assuming you have a Date table, you can just use 

 

Weeks = COUNTROWS('Date'[Date])/7

 

If you don't have a Date table, and potentially have no rows on some dates, you could use

 

Weeks = (DATEDIFF(MIN(Table[Date]), MAX(Table[Date]), DAY)+1)/7

 

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors