measure rental inventory

[GeekAlfPro]

Hello,

i've a table in which i have karting with a start date rental and end date rental.

i'd like to measure the "stock" of rented karts or the available materials which is the opposite

For a given day, if it's between the two dates, the kart is rented, otherwise, not.

i tried a running total, but it sums the data

m_Total cumulé de Nombre de Lien Facturation::N° Contrat Comp dans Date = 
CALCULATE(
	COUNTA('Contrats Location'[Lien Facturation::N° Contrat Comp]),
	FILTER(
		ALLSELECTED('Date'[Date]),
		ISONORAFTER('Date'[Date], MAX('Date'[Date]), DESC)
	)
)

But i don't want a cumulative total, because when the rental is finished, then my kart is available.

My question is 

Can measure that with dax

Or do i have to create a table with power Query that sums by day and the rented karts to display in a chart ?

thanks

i hope i'm clear.

[GeekAlfPro · Accepted solution]

Hello @amitchandak 

Perfect, i manage  to get the figure i was looking for thanks to the following formula !

Current Employees = CALCULATE(COUNTx(FILTER(Employee,Employee[Start Date]<=max('Date'[Date]) && (ISBLANK(Employee[End Date]) || Employee[End Date]>max('Date'[Date]))),(Employee[Employee Id ])),CROSSFILTER(Employee[Start Date],'Date'[Date],None))

Have a good day !

[GeekAlfPro]

Hello @amitchandak 

thanks for the link, i will study them carefully !

[amitchandak]

@GeekAlfPro , based on what I got

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...