Create New Tabe from Existing Table

Question

Hello All,&nbsp;I have below Table&nbsp;&nbsp;Note: WEEK original column from Dataset,&nbsp;2016-2017 till Jun Avg and 2016-2017 after Jun Avg&nbsp;are calculated columns in the below table.&nbsp;WEEK&nbsp;2016-2017 till Jun Avg&nbsp;&nbsp;&nbsp; 2016-2017 after Jun Avg&nbsp;2016-06-W130&nbsp;2016-06-W240&nbsp;2016-07-W1&nbsp;352016-07-W2&nbsp;502017-06-W130&nbsp;2017-O6-W240&nbsp;2017-07-W1&nbsp;352017-07-W2&nbsp;50&nbsp;I need to create a new table as shown below&nbsp;WEEK&nbsp; 2 year Avg&nbsp;2016-06-W1302016-06-W2402016-07-W1352016-07-W2502017-06-W1302017-O6-W2402017-07-W1352017-07-W250&nbsp;Please let me know how to do this.&nbsp;Thank you!

frankat · Accepted Answer

Hi Anonymous,use the following measure:&nbsp;&nbsp;Regards FrankAT

Forum Discussion

Create New Tabe from Existing Table

1 Reply

Related content

Lakehouse Table Generate Create Table

Create new table

Cannot create liquid clustering on existing unpartitioned table

Create a new table from columns from existing tables

Create rows from 2 tables

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

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