Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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.
@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 ) )
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 30 | |
| 29 | |
| 25 | |
| 23 | |
| 16 |
| User | Count |
|---|---|
| 45 | |
| 32 | |
| 17 | |
| 16 | |
| 16 |