Hi all
Regard to Calculating days of supply using DAX... thread I would like to ask you for help. I need to calculate Days of Cover. Data structure is following: WeekDate, Product, ClosingStock, Demand. I tried to use the code from previous thread but I hit on problems.
First one is on the line "VAR CurrentStock = [Closing Stock]" and second one "CALCULATE ( [Demand Quantity], StockExhaustionWeek, ALL ( Week ) )". I dont know what to put there insetead "Closing Stock" and "Demand Quantity". If I use my field "Closing Stock" and my "Demand" instead "Demand Quantity", DAX doesn't like it.
I am absolutely new in DAX.
Thank you a lot.
P.
Regard to Calculating days of supply using DAX... thread I would like to ask you for help. I need to calculate Days of Cover. Data structure is following: WeekDate, Product, ClosingStock, Demand. I tried to use the code from previous thread but I hit on problems.
First one is on the line "VAR CurrentStock = [Closing Stock]" and second one "CALCULATE ( [Demand Quantity], StockExhaustionWeek, ALL ( Week ) )". I dont know what to put there insetead "Closing Stock" and "Demand Quantity". If I use my field "Closing Stock" and my "Demand" instead "Demand Quantity", DAX doesn't like it.
I am absolutely new in DAX.
Thank you a lot.
P.