Skip to Content
avatar image
Former Member

Previous and DaysBetween functions filter

Hi gurus,

I would like to ask you for your help. I have column with dates and I need to create variable with days between and create filter, where is more than 120 days. I want only rows, where > 120. If I use Previous function, I can't filter anything and If I use RelativeValue function, it shows me empty cells.

filter1=DaysBetween([Date traitement];[Previous])*(-1)

filter2=If [filter1] > 122 Then 1 Else 0

Have you any Idea, how I can resolve this problem? Thank you for your replies

111.png (20.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 21 at 10:45 AM

    Hi there,

    Have you tried using the Rank function?

    Rank column 1 -- top 1 based on the filter2 column

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 21 at 11:28 AM

    follow these steps.

    After applying filter on filter1 where greater then 120 you will get the 1 row but previous and filter1 will be blank.

    to display values in the previous variable use nofilter() function. =nofilter([Previous])

    Same if you want to display filter1 in the table then use =nofilter([Filter1])

    Add comment
    10|10000 characters needed characters exceeded