Colomn date over 1year according to the date of to...

ItSupportElm · ‎10-29-2020

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 !

amitchandak · ‎10-29-2020

@ItSupportElm , A measure like this

calculate(countrows(Table), filter(Table,Table[EndDate] > = date(year(today())+1,month(today()),day(today()))))

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

ItSupportElm · ‎11-09-2020

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

Colomn date over 1year according to the date of today

Helpful resources

Fabric Community Update - November 2024

Be one of the first to start using Fabric Databases

Join us at the Microsoft Fabric Community Conference

Power BI Monthly Update - November 2024

Be one of the first to start using Fabric Databases.