Help with 'New Business, 'Returning Business' and 'Lost Business' DAX Calculations
Hi Community This one has baffled me for a while now. I'm trying to come up with the right method and DAX for calculating the following: New Business - Total Sales Amount on an Item & Customer combination that sells for the first time in a rolling 12 month period. Returning Business - Total Sales Amount in 24 months on Item & Customer combination that has ordered in the previous 12 months and has prior 12 months. Lost Business - Total Sales Amount for Item and Customer comination that hasn't ordered in 12 months but has in prior 12 months. I have a date table at the ready, and all of my Sales Data is in one table. So the model is very simple. I'm using SSAS Tabular Live Connection, so any changes would be back end. Any other posts I've found online are looking at number of customers, and aren't specific to 'Item and Customer' combination. Appreciate your help. Thanks Martin
