Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello,
I'm blocked, i have a colomne "EndDate" and i want to display all the date who are over 1 year according to the date of today.
Someone have an idea how to do that please ?
Thank for your futur answer guys !
@ItSupportElm , A measure like this
calculate(countrows(Table), filter(Table,Table[EndDate] > = date(year(today())+1,month(today()),day(today()))))
Hello @amitchandak thank you for your answer and sorry to reply so lately.
I did this measurebut it return me 0 values
do you have an idea why i got this ?
Have a great Day
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 9 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 27 | |
| 22 | |
| 20 | |
| 17 | |
| 12 |