Active Clients

Hi Anonymous

Create a calendar date table in Editor Queries,

Create a blank query->open advanced editor, paste the following code 

let
Source = List.Dates(#date(2018, 1, 1),365, #duration(1, 0, 0, 0)),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "date"}})
in
#"Renamed Columns"

close &&apply,

create relationship between calendar table and your data table (called "Sheet1" in my test) based on "Sheet1"[start date] <->"calendar"[date]

create a measure in Sheet1,

no_count =
CALCULATE (
    COUNT ( Sheet1[client] ),
    FILTER (
        ALL ( Sheet1 ),
        [start date] <= MAX ( 'calendar'[date] )
            && [end date] >= MAX ( 'calendar'[date] )
    )
)

add "calendar"[date] in the Axis, measure in the value field

Best Regards

Maggie