Dear All,
I am indeed need your help...
I am currently trying to develop excel base calculation to find when will the date of stockout for my current inventory compared to demand/consumption.
I am using Excel 365, 2019.
I have 2 lookup tables:
① RepeatOrder_List → Total record > 1000 items
② Date
1 Fact table: All Consumptions/Demand
1 disconnected table _ShortageEstimate → store of Dax Measure
Those table are linked as below:
Basic Measures:
[Consumptions] := SUM( All_ConsumptionNew[DAILY WEIGHT])
[Purchaser Stock] := SUM(All_ConsumptionNew[CC Stock])
And my dax formula for calculating date of stockout ( __PurchaserCovrag ) as below:
The formula is working and I get the result as I wanted as below:
The problem is: It takes more than 3 minute of calculation (reading data displayed in Excel status bar) to get the result.
and often make excel become not responding.
Does anyone can help me here, for reviewing my dax formula or suggest for more effective dax formula.
Thank you
Best regards
I am indeed need your help...
I am currently trying to develop excel base calculation to find when will the date of stockout for my current inventory compared to demand/consumption.
I am using Excel 365, 2019.
I have 2 lookup tables:
① RepeatOrder_List → Total record > 1000 items
② Date
1 Fact table: All Consumptions/Demand
1 disconnected table _ShortageEstimate → store of Dax Measure
Those table are linked as below:
Basic Measures:
[Consumptions] := SUM( All_ConsumptionNew[DAILY WEIGHT])
[Purchaser Stock] := SUM(All_ConsumptionNew[CC Stock])
And my dax formula for calculating date of stockout ( __PurchaserCovrag ) as below:
The formula is working and I get the result as I wanted as below:
The problem is: It takes more than 3 minute of calculation (reading data displayed in Excel status bar) to get the result.
and often make excel become not responding.
Does anyone can help me here, for reviewing my dax formula or suggest for more effective dax formula.
Thank you
Best regards