I have all the dax as per the workshop on customer analytics - works great - thanks.
I’d like to be able to analyse what the customer actually bought . If I simply pull the product name into the analysis the numbers then don’t work - I assume this is because I don’t have any reference to product in the virtual tables?
Here’s what I have:
New Customer Orders = VAR CustomerTM = VALUES( 'Order Intake'[Cust. ID] ) VAR PriorCustomers = CALCULATETABLE( VALUES( 'Order Intake'[Cust. ID] ), FILTER( ALL( 'Calendar'[Date] ), 'Calendar'[Date]> MIN( 'Calendar'[Date] ) - [Churn Time Frame Value] && 'Calendar'[Date] <= MIN( 'Calendar'[Date] ) ) ) RETURN CALCULATE( [Total Orders], EXCEPT( CustomerTM, PriorCustomers ) )
How would I go about adding Product to the available analysis?