Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |