Forum Discussion
Need help understanding Dax (Lost Customers)
Hi Anonymous,
If your sales table only contain the consumption records, you can filter the records by date(for example 2015) then get the customer column from the filtered table and use EXCEPT Function to filter data with customer table.
If above is not help, can you share some sample data?
Regards,
Xiaoxin Sheng
Hi Anonymous
Follow the link
Repeat Customers in DAX: Three Flavors
They are excellent postings on this topic which clearly explain the logic behind doing the calculations.
If this helps please give KUDOS.
Cheers
CheenuSing
Or something like
Lost Customers = CALCULATE(sum(insertBK[InsertNetCost]),'Calendar$'[Year]=2015,var x = CALCULATE(sum(insertBK[InsertNetCost]),'Calendar$'[Year]=2015) = null)
which doesnt work
Hi Anonymous,
If your sales table only contain the consumption records, you can filter the records by date(for example 2015) then get the customer column from the filtered table and use EXCEPT Function to filter data with customer table.
If above is not help, can you share some sample data?
Regards,
Xiaoxin Sheng