Solved: Old customers vs New customers. how to check that?... - Page 2

oristides · ‎07-20-2016

I want to check 2 scenarios

1) I want to compare sales for the customers with less than 1 year old vs clients for more than 1 year old in a period of time X.

2) I want to compare total sales for the clients converted teh LAST YEAR vs the Customers converted THIS YEAR in a period of time X.

I have Converted Date of the customers. Just I don know to performance a Measure our a Running(by time) Column.

Thanks,

v-haibl-msft · ‎07-28-2016

I assume you have a dataset likes below. We can create two measures to get the sales of old and new customers.

For example, B is created on 3/1/2014, then in 2015, old customers are A and B, new customers are C and D.

Sales_OldCustomer = 
CALCULATE (
    SUM ( Sales[Amount in USD] ),
    FILTER ( Sales, YEAR ( Sales[Date] ) > RELATED ( Customer[Created Year] ) )
)

Sales_NewCustomer = 
CALCULATE (
    SUM ( Sales[Amount in USD] ),
    FILTER ( Sales, YEAR ( Sales[Date] ) = RELATED ( Customer[Created Year] ) )
)

Best Regards,

Herbert

Old customers vs New customers. how to check that?? Help