Forum Discussion
Project Last Month's Calculated Cost
Hello, everyone. I need to come up with the unit cost of my company (value/qty) based on the last three months of data and then repeat the last real value for the next X months so I can come up w...
Hello,
I assume the Unit columns are related as well as the date columns.
If you add a measure Total Sum:=SUMX(Stock,Stock[Value_Stock_Total]/Stock[Cant_Stock_Total] you get the global some over all Business Units. Then you can slice or group by Period and BU however you like.
The Units are a dimension. Basically lists the business units and their codes (US, ARG, COL, etc.) so it has no date. The Stock concentrates the date and unit affected.
What you say actually works and I've tried doing it with CALCULATE as well, but the problem remains: how can I project that same value for future months so I can calculate a forecast? Coming up with past values is not a problem.
Thanks!