Dax for counting operations between start & end date

[Anonymous]

Hi All, 

I have a table where start date & end date of operations is available, I want to display number of operations for all dates between those dates. 
(Cannot use cross join as it will create a heavy dataset)

Opeartion	Start Date	End Date
A	1/21/2021	2/10/2021
B	1/23/2021	1/26/2021
C	1/27/2021	2/1/2021
D	1/30/2021	2/3/2021

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please check the below picture and the sample pbix file's link down below.

Operations Count =
CALCULATE (
COUNTROWS ( Operations ),
FILTER (
Operations,
Operations[Start Date] <= MAX ( Dates[Date] )
&& Operations[End Date] >= MIN ( Dates[Date] )
)
)

https://www.dropbox.com/s/7cagrbdsybbn5lr/tejas.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[amitchandak]

@Anonymous , refer to my blog for this

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785