CCC Quarterly BI Convening
Join us for a quarterly meet-up and learning opportunity about Power BI for California Community College research practitioners. The purpose of these convenings is to provide a space for individuals to share their Power BI expertise and to also bring Power BI users together to engage in collaborative learning. For 2024, we will be meeting the fourth Thursday of every quarter (1/25, 4/25, 7/25, and 10/24) at 10:00am. January Agenda Introductions Overview: Jaime Rodriguez, Katy Wilson Chancellor’s Office Update: Erik Cooper Showcase: Success and Retention, D. Martinez; SQL Import Option, D. Buitron. Resources Next meeting/Website You can use this link to sign on: https://lrccd.zoom.us/j/87678134299
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
