topic Weekly split in Developer

Weekly split

Mai_Nashaat — Thu, 14 Oct 2021 11:24:54 GMT

I need to calculate shipments for each week, split weeks of the month as below

at the first row u will find first week starts from 2-Oct to 7-Oct and add 25% of the shipments happened in 9-Oct

and then week2 starts by 75% of shipments in 9-Oct + shipments of 10-Oct and ends by shipments of 14-Oct + shipments of 16-Oct

notice we don't count Fridays.

any help please how can I do that?

@amitchandak @Greg_Deckler

Re: Weekly split

Greg_Deckler — Thu, 14 Oct 2021 11:36:28 GMT

@Mai_Nashaat Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, 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

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Re: Weekly split

Mai_Nashaat — Thu, 14 Oct 2021 13:21:52 GMT

I need to calculate total orders per week as shown in the output table

the issue I've is how to make power bi calculate % of orders of a day to be in week andthe remaining % in other week as the day is split between two weeks

e.g here in the snapshot we have total orders in 9/10/021 is 64

in the split we have 16 in week1and 48 in week 2

Re: Weekly split

Mai_Nashaat — Sat, 16 Oct 2021 19:13:49 GMT

Please check my reply with sample data above

Re: Weekly split

Anonymous — Tue, 19 Oct 2021 05:51:49 GMT

Hi @Mai_Nashaat ,

I'm sorry to say I still don't understand what you want in the end? First you need to divide the number of days per month into four weeks (W1,W2,W3 and W4) and then each week starts on Sunday and ends on Saturday (7 days in total). The value of Saturday of each week is divided in a certain proportion to the current week (25%, 50%, 75%) and the beginning of the next week (Sunday) (75%, 50%, 25%), without counting the value of Friday? By the way is this percentage fixed? For example, if the first week is 25%, the second week 50%, the third week 75% and the fourth week 100%, the corresponding first day of the next week is 75%, 50%, 25%? So based on the example data you provided, is the desired result the data in the table below?

If the above one is not your expected result, please provide more details(backend logic, sample data and expected result with screenshot or special examples) for it. Thank you.

Best Regards