Hi guys, I have been asked by the business to show a count of new customers by year and month. An example of a new customer is a customer who has no revenue for 23 consecutive months followed by revenue on the 24th month. I have measures for monthly revenue and prev 23 months revenue but struggling to show the new customer count in a line graph. I have attached a link to a pbix file with some examples New Customers.pbix.
Appreciate any help you can provide