Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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! | |
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |