urgent help need
1 Topic
Hi Team, could you pls help me to create this calculated table by using dax
Column Names: Date, Max ETA Date, Market, Container Number, Capacity Metrics to Calculate: Number of Containers Delivered (Daily): Every day, only a limited number of containers can be delivered based on the available capacity. Example: If the capacity is 5, then only 5 containers can be delivered that day. Number of Containers Pending Delivery (Daily): This is the number of containers that are still waiting to be delivered. Formula: Pending = Total Containers - Delivered This includes containers from previous days that weren’t delivered due to capacity limits. Total Containers (Daily): This is the sum of: Containers that were pending from the previous day, and New containers added on the current day. Formula: Total = Previous Day's Pending + Today's New Containers sample out put Market Date Max eta date No of containers arrived Capacity No of containers deliverd pending Total India 11-11-2024 11-11-2024 23 5 5 18 India 12-11-2024 12-11-2024 24 5 5 37 42 India 13-11-2024 5 5 32 37 India 14-11-2024 5 5 27 32 India 15-11-2024 5 5 22 27 India 16-11-2024 5 5 17 22 India 17-11-2024 5 5 12 17 India 18-11-2024 5 5 7 12 India 19-11-2024 5 5 2 7 India 20-11-2024 20-11-2024 3 5 5 0 5 India 21-11-2024 21-11-2024 5 5 -5 0 India 22-11-2024 22-11-2024 5 5 5 -5 0 India 23-11-2024 23-11-2024 5 5 -10 -5 India 24-11-2024 24-11-2024 5 5 -15 -10Solved1.9KViews0likes9Comments