Calculation the age between today and birthday

[leazimmer]

Hello together,

i need your help 🙂

My Report need the age from the customer, but i get always a error i don't know why.

Geburtstag and heute is a date Format

This my DAX-Query 1

if
(Date.Year([Heute]) - Date.Year([Geburtstag])
- (if Date.Month([Heute]) < Date.Month([Geburtstag]) then 1 else
if Date.Month([Heute]) = Date.Month([Geburtstag]) and Date.Day([Heute]) < Date.Day([Geburtstag]) then 1 else 0)) < 0 then null
else
Date.Year([Heute]) - Date.Year([Geburtstag]) -
(if Date.Month([Heute]) < Date.Month([Geburtstag]) then 1 else
if Date.Month([Heute]) = Date.Month([Geburtstag]) and Date.Day([Heute]) < Date.Day([Geburtstag]) then 1 else 0))

Secand Query:

Alter =

VAR varAlter =

Year(TODAY())

- Year('konzeptum'[Geburtag])

-(

IF(

Month(TODAY()) < Month([Geburtstag]),

1,

IF(

AND(Month(TODAY()) = Month([Geburtstag]), Day(TODAY()) < Day([Geburtstag]))

,1,

0)

)

)

RETURN

IF([Geburtstag]=BLANK(),

BLANK(),

IF(varAlter <0,BLANK(), varAlter)

)

The error message is, that not found the field "Geburtstag" but this is a date field.

Thanks for your help

Lea

[leazimmer]

I get a error message

Age = datediff('konzeptum'[Geburtstag], today(), year)

Problem with the aggregation 

[amitchandak · Accepted solution]

@leazimmer , if this is measure then

Age = datediff( max('konzeptum'[Geburtstag]), today(), year)

and you need row context

sumx('konzeptum', datediff('konzeptum'[Geburtstag], today(), year))

or

AverageX('konzeptum', datediff('konzeptum'[Geburtstag], today(), year))

or

Sumx(Values('konzeptum'[Kustomer]), calculate(datediff( max('konzeptum'[Geburtstag]), today(), year) ))

[amitchandak]

@leazimmer , You can create new columns

example 

Age = datediff([Geburtstag ], today(), year)