Count Customers aggregately based on their latest status change on a monthly basis
Hi guys, i have this table of customers (Contact Id) with all their status changes along their way on a monthly basis: i wish to calculate by measures the number of customers for each status for each month, which means the latest status available should be considered and calculated until next status change. once a customer has its first change, he should be calculated until current month. There is a table to present what i mean (but in columns. not measures): thanks in advance, Amit
Calculating Retained In Consecutive Months
Hi. I'm trying to calculate the count of players who have deposited in consecutive months (when slicing on any given month). I have a fact table which can have multiple deposits per day containing a [PlayerId] and [DepositDate]. Some metrics I already have setup here are the [Total Depositors] = DISTINCTCOUNT(Deposits[PlayerId]) [First Time Depositors] = CALCULATE(COUNTROWS(Deposits), Deposits[IsFirstDeposit]=1) [Retained] = [Depositors]-[FTDs] The requirement for [Consecutive Depositor] is the count of players that have deposited in consecutive months (not just any previous month). So I'm guessing it's somewhere along the lines of := SUMX( Distinct count of PlayerId where depositor in current month and previous month) It's evaluating whether the particular player has deposited in the previous month that is beyond my DAX capabilities. The highlighted column would be the desired output. Thanks Dave
