Forum Discussion

apuype's avatar
apuype
Frequent Visitor
3 years ago

DatesInPeriod within Selected Value Range

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! 

Need Help

2 Replies

  • apuype's avatar
    apuype
    Frequent Visitor
    3 years ago

    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.