topic Re: Calculating Customer Age at the time of Transaction in DAX Commands and Tips

Calculating Customer Age at the time of Transaction

homeshagarwal — Fri, 23 Jun 2023 04:02:42 GMT

Hi all!

Need help with a DAX code to create a calculation to find out the Customer's Age at the date of the transaction and not as per TODAY. The following is my data model:

My Customer Table and Sales Table are connected based on Customer ID and not on a Date Field.

Could you please help me out here?

Re: Calculating Customer Age at the time of Transaction

tamerj1 — Fri, 23 Jun 2023 04:18:03 GMT

Hi homeshagarwal
So are looking for a calculated column in the Sales table or a measure in report sliced by transaction? Do you have date of birth column for each customer or just the current age of the customer in years?

Re: Calculating Customer Age at the time of Transaction

homeshagarwal — Fri, 23 Jun 2023 04:21:39 GMT

Hi tamerj1
I'm looking to include a Calculated Column in my Sales table to specify the customers' age at the time of the transaction. Also, yes, I do have a Birthdate column in the Customer's table.

Re: Calculating Customer Age at the time of Transaction

tamerj1 — Fri, 23 Jun 2023 04:35:25 GMT

homeshagarwal

Please try

Customer Age = DATEDIFF ( RELATED ( 'Customer Lookup'[Date of Birth] ), 'Sales by Store'[Transaction Date], YEAR )

Re: Calculating Customer Age at the time of Transaction

devanshi — Fri, 23 Jun 2023 05:12:20 GMT

Age = DATEDIFF('Table'[Birthdate], 'Table'[Transaction Date],YEAR)

Re: Calculating Customer Age at the time of Transaction

homeshagarwal — Fri, 23 Jun 2023 05:59:04 GMT

Thanks, tamerj1 !🙌
This was pretty straightforward. Do you know where I messed up?
For some reason, I was trying to add a new column in the Customer's table with this formula earlier 😅😂 so wasn't getting it.