Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |