Create New Tabe from Existing Table

[Anonymous]

Hello All,

I have below Table 

Note: WEEK original column from Dataset, 2016-2017 till Jun Avg and 2016-2017 after Jun Avg are calculated columns in the below table.

WEEK	2016-2017 till Jun Avg	2016-2017 after Jun Avg
2016-06-W1	30
2016-06-W2	40
2016-07-W1		35
2016-07-W2		50
2017-06-W1	30
2017-O6-W2	40
2017-07-W1		35
2017-07-W2		50

I need to create a new table as shown below

WEEK	2 year Avg
2016-06-W1	30
2016-06-W2	40
2016-07-W1	35
2016-07-W2	50
2017-06-W1	30
2017-O6-W2	40
2017-07-W1	35
2017-07-W2	50

Please let me know how to do this.

Thank you!

[FrankAT · Accepted solution]

Hi @Anonymous,

use the following measure:

Regards FrankAT