DAX calculate Previous month lost customer revenue
Hi guys, I am having trouble calculating the previous month lost customer revenue. My model relies on a single way relationship between thr fact table and the time table, so that is not possible to change. I would like to display the measure "Churn_lost_$" as shown in the picture below. Thank you very much! 🤙 You can donload the model here: https://drive.google.com/file/d/1MKFmtBIm1Z-yJ0--FhVRuIrZqWVV166c/view?usp=sharingHELP!!! calculating LOST CUSTOMERS
HI friends, I am creating a customer lost calculation and I'm able to calculate it in the subtotals correctly but unable to place it in the row level as the customer does not appear that month. I show you: Also I would like to calculate the money that the customer 493 spent in the past month. But appearing in february in it's new line. Please fins attached the PBI file HERE https://drive.google.com/file/d/13Bdh978nHmrAZWro06cOMaQ2J4ggTV0e/view?usp=sharing Thank you very much!!!
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!!
