cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Percentage of total sales on weekly basis

Hi everyone,

 

I have question regarding the percentage of total sales on a weekly basis per products.

I want to show up the shares of a product compared to the total sales of the week / several weeks.

Therefore I created a column in Power BI: Net sales/sum(net sales).

The problem is that the sum of net sales does not change when I select different calendar weeks. To make it clear I have an example:

 

Week 3

Sales Product A: 10.000€

Sum of Sales: 150.000€

Percentage: 6,67%

 

Week 3+4

Sales Product A: 25.000€

Sum of Sales: 150.000€

Percentage: 16,67%

 

Do you have any idea how to create a measure oder column which shows a dynamic sum of total sales based on the calendar weeks?

 

Thanks in advance and best regards

Manuel

2 REPLIES 2
Super User
Super User

Re: Percentage of total sales on weekly basis

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Community Support Team
Community Support Team

Re: Percentage of total sales on weekly basis

Hi ManCervi,

 

"

Week 3

Sales Product A: 10.000€

Sum of Sales: 150.000€

Percentage: 6,67%

 

Week 3+4

Sales Product A: 25.000€

Sum of Sales: 150.000€

Percentage: 16,67%

"

 

<--- Could you share some sample data and clarify more details about your requirement?

 

Regards,

Jimmy Tao