Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Qualifying Date for Date-Range

Hello all   I have a table of objects. These objects are available within a data range. dateActiveOn = active since dateDeadOn = inactive from   I now need to set a qualifying date to show o...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous

    Explaination for the formula as below

    qualifying1 =
IF (
    [selected date] < MAX ( Sheet5[datedeadon] ) //"max" -> get the current row of a column,
        && [selected date] >= MAX ( Sheet5[dateactiveon] ),
    1,
    0
)

     

     

    I make a new test as below

     

    in my test, [DeadActiveOn] is date/time type, DateDeadOn and Date (Date table) are in date type.

     

    Could you share a screenshot to let me know your data and what's error of the qualifying measure?

     

     

    Best Regards

    Maggie

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

It is possible to do this with the Query Editor.  The 2 date columns can be merged into  single one.  To get more specific help, share some data and show the expected result.