Forum Discussion
Solved
Age bracket : Conditional Formatting not working
Hi all, a helpless newbie here. I want to create a measure (not calculated column) that : categorises a customer according to their age when they sign up This is what I hope to achieve ...
holywasabi , Try using below dax
Customer Age Group =
VAR CustomerAge = [Customer Age (Based on year signed-up)]
RETURN
CALCULATE(
VALUES('Age Group'[Age Group]),
FILTER(
'Age Group',
CustomerAge >= 'Age Group'[Min] &&
CustomerAge <= 'Age Group'[Max]
)
)
This works, thank you very much! 😊