This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
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 ) )
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 37 | |
| 32 | |
| 27 | |
| 24 | |
| 17 |
| User | Count |
|---|---|
| 70 | |
| 50 | |
| 31 | |
| 25 | |
| 24 |