Dynamic Day calculation based on week

[Anonymous]

Hi Guys, i have a complex scenario as explained below.

i want to pull a weekly report for employees who applied for no of days of WFH in a week.

i want to find this based on WFH applied dates.

can you please tell me what is the best approach to capture the no of days for the selected week?

from the below example is Out put1 or Out put2 is possibile? how to achieve both the outputs?

But we need to calculate the no of days only for the given week, an employee can apply wfh for multiple days but we need to count the days only for the given week based on the from and to date.

@tamerj1 @amitchandak @Jihwan_Kim @daXtreme @Greg_Deckler @Pragati11 @mwegener 

@parry2k @lbendlin @PaulDBrown 

Employee Number	Applied on	From date	To Date		Expected Output 2	WFH Date
12345	20-08-2022	25-08-2022	26-08-2022		12345	25-08-2022
34567	25-08-2022	26-08-2022	31-08-2022		12345	26-08-2022
87969	22-08-2022	23-08-2022	06-09-2022		34567	26-08-2022
					34567	27-08-2022
Reporting week Aug 22nd to 26th					34567	28-08-2022
Expected output 1					34567	29-08-2022
					34567	30-08-2022
Employee Number	No of days of WFH applied for the week		34567	31-08-2022
12345	2 Days				87969	23-08-2022
34567	1 Day				87969	24-08-2022
87969	4 Days				87969	25-08-2022
					87969	26-08-2022
					87969	27-08-2022
					87969	28-08-2022
					87969	29-08-2022
					87969	30-08-2022
					87969	31-08-2022
					87969	01-09-2022
					87969	02-09-2022
					87969	03-09-2022
					87969	04-09-2022
					87969	05-09-2022

[PaulDBrown · Accepted solution]

See the suggestion I posted in your other thread (please don't duplicate threads in different fora: it dilutes knowledge)

https://community.powerbi.com/t5/Service/Dynamic-Day-calculation-based-on-weekly/m-p/2792514#M174104 

[Anonymous]

@PaulDBrown  i agree with you, just want to get the solution anyway marking it as solved. thanks for your efforts and time