topic Re: Graph Actuals vs. Projections in DAX Commands and Tips

Graph Actuals vs. Projections

Drogov4122 — Mon, 14 Aug 2023 16:21:32 GMT

I created the attached graph based on actual monthly numbers and is being refreshed automatically. However, I do not want to see the drop in 2023 levels since the numbers are only for 14 days, hence the sharp drop compared to the other values. What would be the best method to perhaps insert an average begging in August or something similar to make a projection instead of the drop?

Re: Graph Actuals vs. Projections

Syk — Mon, 14 Aug 2023 18:31:25 GMT

Best way would be to do an average daily rate for the month. For example, for August it would show 2.3 since there are 14 days right now. July would show 2.6

Re: Graph Actuals vs. Projections

Anonymous — Tue, 15 Aug 2023 17:51:36 GMT

Maybe you could try using the linear regression function for this case and add the comment that's a calculus that's coming from previous months averages.