Generating new column values from existing table using DAX

[jsevillaiv]

Let's say I have a data like this:

A table with "wave" column which has a unique numerical value.

Using the table above, the goal is to generate a table like below:

Basically, to generate 4 records consist of decremental values for each "wave" value:
ex.
72 = 69 to 72
73 = 70 to 73
74 = 71 to 74

Is it possible to achieve this using DAX?

Thanks in advance!

[johnt75]

You can create a new table like

new table =
SELECTCOLUMNS(
	GENERATE( 'wave', GENERATESERIES( 'wave'[wave] - 3, 'wave'[wave], 1 ) ),
	"wave", 'wave'[wave],
	"wave_coverage", [Value]
)

[HotChilli · Accepted solution]

Create the new table like this:

TableNew = 
    GENERATE (
        TableQ,
       GENERATESERIES(TableQ[Column1] - 3, TableQ[Column1],1) )