COUNT YTD (Start and End Date)

[Anonymous]

Hi,

I am trying to create da schedule matrix counting tasks between dates, like the example bellow

My database is something like that

Task	Type	Start	End
Task 1	Type 1	jan/20	mar/20
Task 2	Type 2	jan/20	mar/20
Task 3	Type 3	fev/20	set/20
Task 4	Type 2	jun/20	dez/20
Task 5	Type 3	jun/20	dez/20

And I'm trying to create a matrix like that

	jan/20	fev/20	mar/20	abr/20	mai/20	jun/20	jul/20	ago/20	set/20	out/20	nov/20	dez/20
Type 1	1	1	1
Type 2	1	1	1			1	1	1	1	1	1	1
Type 3		1	1	1	1	2	2	2	2	1	1	1

Any ideias about how can I create a measure that count and accumulate events between dates?

Thanks!

Raphael Lins

[Greg_Deckler · Accepted solution]

Open Tickets: https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364#M147