Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I'm stuck with this and i can't find a solution on the spider. I have 3 tables in each one there is a quantity (forecating production, receipt goods, inventory) and I need to forecast our inventory with the last inventory entree. so the simple formula is :
Initial inventory + receipt - forcasting production
I create a measure to find the last inventory
Stock initial:=CALCULATE(SUM(Stock[Quantité]);LASTDATE(Stock[Date]))
the another one to forecast the inventory
projection:=Stock[Stock initial]+[Total réception]-[Total prevision]
and this what i got in the pivot table
in the header row those number are week number and number of woking days, in the "projection" line I want a cumulative forecast
any help Please
any Help please
In this scenario, you want to calculate the cumulative total for that "forecast". Since your "forecast" value is from a measure, to apply calculation on these values, you have to summarize that measure into a column. So you may create a calculated table, then calculate this "cumulative forecast".
Regards,