Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Filter data with date column

Hello everyone, I'm new with Power BI and I need to filter data with a date colum so Iwant to get only the data that is before 60 days(2 months) comparing to the ddate column value.

here an examlpe, I want the data which the date of last checkin is more than 60 days before => line 1 and 2 = No, line 3 and 4 = Yes, line 5 No.

Like this one but the condition must be "NOT IN"

Thanks in advance for ypur help.

Tips and Tricks

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , You can create a measure and use that in visual or visual level filter

     

    calculate(Sum(Table[Value]), filter(Table, Table[Date] <= today() -60 ) )