Hi everyone! I’m trying to evaluate the new business that a Sales Rep is bringing to the company vs. existing business.
I want to do something similar to what you show i
Preformatted textn the Calculating New & Existing Customer Sales, but I want to base it on the Hire Date in the Sales Rep table, not the MIN date selected. Would I just swap out MIN(Dates[Date]) with MIN(Sales Rep[Hire Date])? Would that work?
Thanks for your help!
Here’s the DAX for the New Customer Sales that I’m referencing:
New Customer Sales = VAR Customers = VALUES( Sales[Customer ID] ) RETURN CALCULATE( [Total Sales], FILTER( Customers, CALCULATE( COUNTROWS( Sales ), FILTER( ALLSELECTED( Dates ), Dates[Date] < MIN( Dates[Date] ) ) ) = 0 ) )