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!!!
Calculate attrition with distinct clients ids
Hello Experts, I have a report table with : - Multiple Report periods with same values (one by reseller active contract over period): 01/01/2021,01/12/2021,01/11/2021 .... - Those resellers can have multiple contracts with the same reference for the same period. I must retrieve the distinct lost contracts from previous periods ( month -1, month -2 ...) I have tried comparing two results with except but i don't know why this is not working as it doesn't return correcly my reseller ref. Attrition M = var _Q = SELECTEDVALUE(Revenue[Period]) var _Q_1 = DATEADD(Revenue[Period],-1,MONTH) var _Resellers = CALCULATETABLE(DISTINCT(Revenue[Reseller Ref]), FILTER (ALL(Revenue[Period]), Revenue[Period] = _Q)) var _Old_resellers = CALCULATETABLE(DISTINCT(Revenue[Reseller Ref]), FILTER (ALL(Revenue[Period]), Revenue[Period] = _Q_1)) RETURN COUNTROWS( EXCEPT(_Old_resellers,_Resellers) ) I give you a sample with my queries in attachment: powerbi_sample Regards.
