Row average of most recent 6 months

[murthybhs]

Hello everyone! Hope everyone is staying safe during the pandemic.

I have a data set that looks like below. I tried searching for the solution in the community but I might be lacking the right search terms to use.

Every month, a new column gets layered over with the data for the most recent month and I need to find the row average for the most recent 6-months.

Looking at my data below, the first table has a calculated average of rows A and B form Jan2020 to Jun2020.

In the second table, a new column for Jul2020 was added and has a calculated average of rows A and B from Feb2020 to Jul2020.

Any help on this would assist me in learning new concepts. As always, thank you so much!

[atcodedog05 · Accepted solution]

Hi @murthybhs 

Here is a workflow for the task.

Output:

Case 1

Case 2

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Happy to help 🙂 @murthybhs 

Cheers and Happy Analyzing 😀