Forum Discussion
Charts
Morning!
Context: Every month around 70 people give me their forecast numbers for the whole year (2024). This means that in January, they give me 12 months forecast. In February, they give 11 months forecast (can change from prior month) and January's actuals (static), In March they give me 10 months forecast (can change form prior month) and January's and February's actuals (static), and so on.
I have multiple tables, each one of them for the month I receieve the new numbers. I want to create something that will show them how much does their forecast change month to month, either up or down. It comes to my mind adding measures to create a growth chart but I have never done one and wondering if there might be an easier way.
Thanks!
2 Replies
Rather than having each forecast be its own table, I would suggest appending them. As long as you have a column in each on that says the date of the forecast. Like, in January the field could be 1/1/2024, the Feb file would be 2/1/2024. Then you could use the quick measure for MoM change based on the field with the date. So, you could see what was March forecasted based on a MoM of Jan and Feb and see how much they changed their forecast from file to file.
Hi Audrey, thank you very much for you reply, greatly appreaciated!
Quick question for you. I do have my separate tables and I think I can append them. Each table is named after the month I received the information. (April, May, June, July...) Which means all projects would repeat 'x' amount of times. How would you recommend doing it?
Basically I have 6 tables like the before, with slight changes in numbers
