I'm struggling to figure out what seems like a simple task. I would like to display a card that shows the number of "new customers" in a given time period. I'm able to generate a list of accounts in a table by using the following:
isFirstOrder =
IF( CALCULATE(MIN('Sales Data'[invoice_date]),ALLEXCEPT('Sales Data','Sales Data'[Customer]))=MAX('Sales Data'[invoice_date]), 1, BLANK())
I just want to show the number of new customers in a card. Any help would be greatly appreciated.
