Forum Discussion
Calculating Age on a Given Date
Anonymous
My apologies for late reply
You can first create a small parameter table defining your age buckets for example
Bucket Age End Age Start Infant 2 0 Teenager 20 2 Adult 60 20 Senior Citizen 200 60 Then you can use a MEASURE like this
Measure = VAR AgeStart = SELECTEDVALUE ( Buckets[Age Start] ) VAR AgeEnd = SELECTEDVALUE ( Buckets[Age End] ) RETURN COUNTROWS ( FILTER ( VALUES ( Table1[Client Name] ), [BirthDate1] > AgeStart && [BirthDate1] <= AgeEnd ) )[BirthDate1] is the Measure we created before
Please see the attached file for clarity
Hi,
I have a table with client details, including date of birth, how would I go about calculating the age of these clients on any given date (Which the end user can filter on). the aim of the exercise is to see the age demographics on any given date in the past.
Thanks
Community ChampionAnonymous
My apologies for late reply
You can first create a small parameter table defining your age buckets for example
| Bucket | Age End | Age Start |
| Infant | 2 | 0 |
| Teenager | 20 | 2 |
| Adult | 60 | 20 |
| Senior Citizen | 200 | 60 |
Then you can use a MEASURE like this
Measure =
VAR AgeStart =
SELECTEDVALUE ( Buckets[Age Start] )
VAR AgeEnd =
SELECTEDVALUE ( Buckets[Age End] )
RETURN
COUNTROWS (
FILTER (
VALUES ( Table1[Client Name] ),
[BirthDate1] > AgeStart
&& [BirthDate1] <= AgeEnd
)
)
[BirthDate1] is the Measure we created before
Please see the attached file for clarity
Thanks @Zubair_Muhammad, don't need to apologies, I'm slower in responding.
Your solution worked, thanks!