What is the best function on the below use case: TimeSum or MovingSum ? (For best performance)
Generally it is suggested to use the TimeSum function if my target is not dimensioned by time.
If my target is dimensioned by time, it is better to use MovingSum. But MovingSum doesn't allow start period parameter other than the number data type.
What can we do if my target is dimensioned by time and my start period parameter is month data type and not a number. Should we use TimeSum or MovingSum (after converting month to number)? Which is best for performance?
I attached sample working in the excel where I am achieving the desired result with multiple ways. But would like to get your suggestion to get result by keeping performance as a top priority.