Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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👍
Proud to be a Super User! | |
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👍
Proud to be a Super User! | |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |