need help this calculated table by using dax

tkavitha911 , Try using

CalculatedTable =
VAR CalendarTable = ADDCOLUMNS(
CROSSJOIN(
VALUES(Calendar[Date]),
VALUES(Inbound_Query[Supply Category])
),
"Market", Inbound_Query[Market],
"Max ETA", Inbound_Query[Max ETA Date],
"Clearance Days", Inbound_Query[Clearance Days],
"Capacity", Inbound_Query[Capacity]
)
VAR ContainerCountTable = ADDCOLUMNS(
CalendarTable,
"Container Count",
CALCULATE(
COUNTROWS(Inbound_Query),
FILTER(
Inbound_Query,
Inbound_Query[Supply Category] = EARLIER(CalendarTable[Supply Category]) &&
Inbound_Query[Market] = EARLIER(CalendarTable[Market]) &&
Inbound_Query[Max ETA Date] = EARLIER(CalendarTable[Date])
)
)
)
VAR PredictedDeliveryTable = ADDCOLUMNS(
ContainerCountTable,
"Remaining Containers",
VAR CurrentDate = CalendarTable[Date]
VAR CurrentMarket = CalendarTable[Market]
VAR CurrentSupplyCategory = CalendarTable[Supply Category]
VAR CurrentCapacity = CalendarTable[Capacity]
VAR CurrentContainerCount = ContainerCountTable[Container Count]
VAR PreviousRemainingContainers =
CALCULATE(
SUMX(
ContainerCountTable,
ContainerCountTable[Remaining Containers]
),
FILTER(
ContainerCountTable,
ContainerCountTable[Date] = CurrentDate - 1 &&
ContainerCountTable[Market] = CurrentMarket &&
ContainerCountTable[Supply Category] = CurrentSupplyCategory
)
)
VAR TotalContainers = CurrentContainerCount + PreviousRemainingContainers
RETURN
IF(
TotalContainers > CurrentCapacity,
TotalContainers - CurrentCapacity,
0
),
"Predicted Delivery Date",
IF(
ContainerCountTable[Remaining Containers] > 0,
CalendarTable[Max ETA] + CalendarTable[Clearance Days] + 1,
CalendarTable[Max ETA] + CalendarTable[Clearance Days]
)
)
RETURN
SELECTCOLUMNS(
PredictedDeliveryTable,
"Market", [Market],
"Supply Category", [Supply Category],
"Max ETA", [Max ETA],
"Container Count", [Container Count],
"Remaining Containers", [Remaining Containers],
"Capacity", [Capacity],
"Clearance Days", [Clearance Days],
"Predicted Delivery Date", [Predicted Delivery Date]
)

Hi, 

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

expected result table = 
	VAR _condition = SELECTCOLUMNS(
		SUMMARIZE(
			ADDCOLUMNS(
				ADDCOLUMNS(
					SUMMARIZE(
						inbound_query,
						inbound_query[market],
						inbound_query[supply_category],
						inbound_query[max_eta],
						inbound_query[capacity]
					),
					"@container_count", CALCULATE(COUNTROWS(DISTINCT(inbound_query[container_number])))
				),
				"@condition", IF(
					inbound_query[capacity] < [@container_count],
					1,
					0
				),
				"@remaining_containers_count", IF(
					[@container_count] - inbound_query[capacity] > 0,
					[@container_count] - inbound_query[capacity],
					0
				)
			),
			inbound_query[market],
			inbound_query[supply_category],
			inbound_query[max_eta],
			[@container_count],
			[@remaining_containers_count],
			[@condition]
		),
		"@m", inbound_query[market],
		"@s", inbound_query[supply_category],
		"@container_count", [@container_count],
		"@remaining_containers_count", [@remaining_containers_count],
		"@maxeta", inbound_query[max_eta],
		"@condition", [@condition]
	)
	VAR _t = GENERATE(
		inbound_query,
		FILTER(
			_condition,
			[@m] = inbound_query[market] && [@s] = inbound_query[supply_category] && [@maxeta] = inbound_query[max_eta]
		)
	)
	RETURN
		SUMMARIZE(
			ADDCOLUMNS(
				SUMMARIZE(
					_t,
					inbound_query[market],
					inbound_query[supply_category],
					inbound_query[max_eta],
					[@container_count],
					[@remaining_containers_count],
					inbound_query[capacity],
					inbound_query[clearance_days],
					[@condition]
				),
				"@predicted_delivery_date", inbound_query[max_eta] + inbound_query[clearance_days] + [@condition]
			),
			inbound_query[market],
			inbound_query[supply_category],
			inbound_query[max_eta],
			[@container_count],
			[@remaining_containers_count],
			inbound_query[capacity],
			inbound_query[clearance_days],
			[@predicted_delivery_date]
		)

Hi tkavitha911,

I am following up to see if you had a chance to review my previous response and provide the requested information. This will enable us to assist you further.

Regards,

Vinay Pabbu