Auto replicate value between two dates

[Desauv]

Hi

So this might be a fairly simple question, but I have this table below

ID	Start Date	End Date	Count
XXX1	01-01-2022		1
XXX2	01-05-2022	01-08-2022	1

How do I make a visible that shows the sum of count every month, based on start and end date? 

The visual should show below numbers. If no "End Date" it should keep showing the value based on the user selected period.

January	February	March	April	May	June	July	August	September	October
1	1	1	1	2	2	2	2	1	1

Thanks 🙂

Regards 

Stefan

[v-xiaotang · Accepted solution]

HI @Desauv 

Thanks for reaching out to us.

please try this measure

count = COUNTX(FILTER('Table','Table'[Start Date]<=MIN('calendar'[Date]) && ('Table'[End Date]>=MAX('calendar'[Date]) || ISBLANK('Table'[End Date]))),[ID])

sample data

calendar

result

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.