see the attached approach use superstore $ YOY
this calculation will give you the average - it is a table calculation so you need to set it up in relation to your data table
it returns this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
dollar yoy.twbx 1.2 MB