Create coluna with inventory of animals from another table

[Syndicate_Admin]

Good afternoon.
I've been trying for weeks to create a DAX formula that returns for each date in a calendar table the inventory of animals for that day. It is a farm.
In the general data table I have line by line the data of each animal (it can be repeated so I only have to add different numbers), specifically for this case the date of entry (entries) and date of sale or death (exits). Each line has columns with the date of entry, sale and death

So I wanted to create a new column in the calendar table with the formula:
For an inventory date - each row of the table:
Sum of animals (different IDs) on farm for this date = animals that exist in the database minus animals with entry date > to date of each row and minus with date of death and sale < date of row.

You could help me in the DAX script. I look in courses and internet but I can't get it. It's already too much for me...
Attached example of the data table where each line has animal dice that must be added the non-repeated and use formulas of > entry date and > that sold date or dieaddate
Thanks a lot!!

[v-shex-msft · Accepted solution]

Hi @DBrito79 ,

It seems like a common date fields analysis requirement, I'd like to suggest you take a look at the following blog start date, end date parts if helps:

Before You Post, Read This: start, end date  

Regards,

Xiaoxin Sheng