age groups
1 Topic
years between dates + categories using measures only
Hi There, I have been searching the forum but I can't find any posts that tackle my specific issue. I am building reports for a renting company and I and can only make measures, not calculated colums or new tables. I have the following two dimensions connected through Customer_ID: Customer_ID BirthDate 1 1-1-2006 2 3-6-1970 3 24-5-1998 4 4-9-2008 5 12-2-2023 and Order_ID Customer_ID Rent_StartDate Rent_EndDate 1 1 7-4-2023 21-6-2023 2 2 12-4-2023 22-6-2023 3 3 1-5-2023 4 4 8-5-2023 5 5 23-5-2023 What I am trying to do is two things: 1) calculate the customer's age in years at the start of the renting period and 2) organise these years in age-categories. With only measures. Just for context: I am already reporting the total orders (per month, based on Rent_StartDate) and I want to add the average age at the start of the rent, and the specific age groups at the start of the rent. So something like this: April May # Orders 2 3 avgAgeCustomer # Customers 16-20 # Customers 21-25 # Customers 26-30 # Customers >30 Anyone here have an idea on how to tackle this issue? Thanks!!Solved564Views1like2Comments