Forum Discussion

jsevillaiv's avatar
jsevillaiv
Frequent Visitor
3 years ago
Solved

Generating new column values from existing table using DAX

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!

Need Help
  • HotChilli's avatar
    HotChilli
    3 years ago

    Create the new table like this:

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

2 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    3 years ago

    Create the new table like this:

    TableNew = 
    GENERATE (
        TableQ,
       GENERATESERIES(TableQ[Column1] - 3, TableQ[Column1],1) )
  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    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]
)