Count of dates in a column

Hi David,

Yes we should have a date table in the model.

May I guess that you use the start date column as row input in the chart visual. Is this correct?

If you change it to completion date, then the count will be wrong for start date but right for completion date.

Add a Date table relate the must important date (start date or completion date) to the date table. Create a inactive relationship to the completion date (after you have created the relationship to start date create a relationship to completion date). You can recognise an inactive relationship be the dashed line.

All visuals which need to be group by date must be grouped be fields in the date table.

Now create two measures:

CountCompletionDate=Calculate(count([completion date],userelationship(Dates[date]),"the name of your table"[completion date]))

CountStartDate=Count("the name of your table"[start date])


Use the date from the date table and add the two measures to the chart.

Do you have a date table?

If not I am happy to send you one.

I don't want you to write your email address here, because it is a public forum, but send an email to info@stl-training.co.uk if you want me tp forward you my date table I use in all my data models.

Please type forward to Jens in the Subject

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector