Solved: Find Items over 2 years that are still open

Anonymous · ‎10-21-2021

Hi Experts

I have a date in my issues tables. I want a calculated column with the value of 1 for all issues that are still open and over 2 years old from todays date.

All items from todays date and within 2years of todays date show as zero.

Greg_Deckler · ‎10-21-2021

@Anonymous Not really enough information to go on but should be something like:

Column = IF([Status]="Open" && (TODAY() - [Date]) > 730, 1, 0)

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Greg_Deckler · ‎10-21-2021

@Anonymous Not really enough information to go on but should be something like:

Column = IF([Status]="Open" && (TODAY() - [Date]) > 730, 1, 0)

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...