I have a list of customer details that includes their birthdays.
I need several things from this list.
The first is a list of customers that are having a birthday in the next month (not this month but the next one).
I get this by creating a virtual table
Birthdays in next month = FILTER( 'Customers', CONTAINS( ADDCOLUMNS( CALENDAR( TODAY() + 1, TODAY() + 31), "Month", MONTH( [Date] ), "Day", DAY ( [Date] ) ), [Month], MONTH( 'Customers'[Birth Date] ), [Day], DAY( Customers'[Birth Date] ) ) )
This gives me the basic details of what I need for their birthday for next month.
I can replicate the same logic to give me the details for the current month but this seems a bit excessive. I was wondering if there was a better way to do both at once.
The second thing I need to do is identify the milestone birthdays (18, 21, 30, 40, 50, 60, 70, 80, 90, 100)
Finally, I want to create a visualisation where I show a summary of the number of birthdays per month.
Looking for ideas on how to achieve these goals