DatesInPeriod within Selected Value Range

[apuype]

Hi all!

Looking for assistance for a scenario that my brain thinks as simple but I cannot get the dax no matter which way I try it. 

I have a basic table with time off requests 

I need to calculate leave length totals - which I can do, however the next layer to that is leave length totals within a selected date range

For example if I I look at the month of February I do not want the value for user ABC to be 41, I only want it to be 28 days for 02/01/23-02/28/23 - so how much time off was within the month of February.

I have done many custom time intelligence formuals due to some custom calendars but this one has me stumped. 

Thank you! 

[apuype]

Thank you, this is making sense to me for when a user is only using a month slicer. The slicer I am using gives a period and then using that period there is a start and end date

I have a special dates table to account for what period each date falls in, I then have that related to our main date table which holds the unique values and that then relates to my data

Thinking I could do something with your logic above that involves using my start of this period, end of this period measures? 

Thanks again! I will be saving your measure above for when I am working with standard periods. 

[Padycosmos]

Hope this measure helps: