Forum Discussion

john_hqi's avatar
john_hqi
New Member
9 years ago
Solved

Determine if date is between 2 dates

I have a table with an End Date for a record. I need to determine if this end date is between a start date and end date for a custom 5 year contract quarter. I was thinking of just doing this in DAX ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi john_hqi, 

     

    I tested mmace1's idea. It works. Please have a try.

    1. Create a table "Quarters".

    2. Add a calculated column:

    Column =
CALCULATE (
    VALUES ( Quarters[Value] ),
    FILTER (
        'Quarters',
        'Quarters'[Start] <= EARLIER ( 'Calendar'[Date] )
            && 'Quarters'[End] >= EARLIER ( 'Calendar'[Date] )
    )
)

    3. If more quarters neeed, we can add to table "Quarters".

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

     

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Silko,

 

I'm glad it can help you. Please open a new thread of your question.

 

Best Regards,

Dale

Silko's avatar
Silko
Helper II
8 years ago

Here is the new thread. I was not sure what the subject should be so it was simpler to ask the question here. :)