topic Re: Dynamic age calculation in Custom Visuals Development Discussion

Dynamic age calculation

Clemerson — Mon, 26 Sep 2022 19:03:05 GMT

Good afternoon

I'm trying to make a dynamic age calculation, using a filter using a D_Calendar,I have a column with the date of birth, from it performed the age calculation

"Dynamic Age = DATEDIFF([Birth Date],NOW(), YEAR)", it turns out that When I change the date filter indicated in the attached image that the age is also recalculated, Tried in several ways and could not, does anyone know how to do?

Re: Dynamic age calculation

Greg_Deckler — Mon, 26 Sep 2022 19:11:51 GMT

@Clemerson Not sure what you are trying to do with the date slicer but if you don't want the birthday to change you could do this:

Dynamic Age Measure = VAR __Name = MAX('Table'[Name]) // some identifier VAR __BirthDate = MAXX(FILTER(ALL('TAble'),[Name] = __Name),[Birth Date]) RETURN DATEDIFF(__BirthDate ,TODAY(), YEAR)

Re: Dynamic age calculation

Clemerson — Mon, 26 Sep 2022 19:42:18 GMT

Thank you for your help,
Actually the date of birth I already have static

what I need is for dynamic age to change when I filter a different date

example: Today 09/26/2022 the age is 80, when put in the filter the date of 09/26/2023 the age would have to change to 81, I don't know if I could explain it right.

Re: Dynamic age calculation

Greg_Deckler — Mon, 26 Sep 2022 19:47:14 GMT

@Clemerson So maybe this:

Dynamic Age = DATEDIFF([Birth Date],MAX('Table'[Date]), YEAR)