Getting a future age

[guyatisk]

I dont need someone to do this for me, but give me hints, advice, a point in the right direction.  And for some, this ask might be pretty simple.  In our data of customers, we have a request to list any clients that are going to turn 18 in the next three months.  They also want another list of clients who will be turning 21 in the next three months.  Is there an AGE formula or would I use a DateDiff function?

Any advice is appreciated.

[FreemanZ · Accepted solution]

hi @guyatisk 

use DATEADD to shift years to simulate future ages.

[Idrissshatila · Accepted solution]

Hello @guyatisk ,

You could also check SQLBI's article https://www.sqlbi.com/blog/marco/2018/06/24/correct-calculate-of-age-in-dax-from-birthday/

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍

Follow me on Linkedin

[FreemanZ · Accepted solution]

hi @guyatisk 

use DATEADD to shift years to simulate future ages.