Detect Past Month lost customer
Hi, I'm trying to find the customers that I lost from the previous month. So far I've been able to calculate it individually but I'm stuck with the subtotals. The model is a single table inndicating if a customer is active or not. The expected outcome is the measure "Lost". The measure for past months looks like this (works fine): Past Month =: VAR var1 = CALCULATE( SUM(Consulta1[Active]), PREVIOUSMONTH(Consulta1[Date]) ) RETURN var1 The measure for lost looks like this (the subtotals don't work fine): Lost = VAR var1 = SUM(Consulta1[Active]) - [Past Month] RETURN IF( var1>=0, BLANK(), var1 ) Any idea? Thanks!!
