Forum Discussion
Relative age?
Hey everyone. So, I've calculated the age of my "customers" by a simple dax: Age =
DATEDIFF(
MAX(Dim_Customer[Birthday]);
TODAY();
YEAR
) and it, of course, works perfect...
grggmrtn ok so just so that i understand what you asking
you want to take the year (sales year?) and work out how old they were in that year?
vanessafvgYes, exactly. I want to take the current year (not sales year) and find out how many customers there were in each age group - their age at that time.