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 ge...
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) )
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) )