Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
@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)
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.
@Clemerson So maybe this:
Dynamic Age = DATEDIFF([Birth Date],MAX('Table'[Date]), YEAR)