Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Active Clients by Month

Hi   I am new to Power Bi and need some help in trying to be able to calculate "active clients" by program each month. I am using a connection directly to a CMS system which is providing me with th...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi, Anonymous. If I understand your goal, you can use the FILTER function together with a DATE table in order to get just the active clients between the dates. Try something like this:



Active Clients =
CALCULATE (
    COUNT ( NameTable[Clients] );
    FILTER (
        NameTable;
        NameTable[program_start_date] >= MIN ( Date[Date] )
            && NameTable[program_end_date] <= MAX ( Date[Date] )
    )
)