Hi Sam,
Just watched the video on “Dynamic Scenario Analysis of Average Order Size”, particularly for the different way to get a cumulative total, nice one.
Looking at the DAX formula to increase the order size, I am puzzled. It seems that the formula merely adds a selected value (ordersize) to the average sales amount, which I guess is not the intention?
Paul
Yes I think it was intentional. It’s obviously not the perfect representation as it’s just an average initially, but I think it produces a fair calculation ultimately that adds some value.
Sam