GENERATESERIES with incrementvalue 1. How to add calculated columns with incrementvalue 5 and 10

[JulieB_]

Hi, I created a table where first column is a GENERATESERIES. 

Now I want to add columns likt this : 

Columns with different increment values based on the first generateseries column.

Value	5series	10series
1	5	10
2	5	10
3	5	10
4	5	10
5	5	10
6	10	10
7	10	10
8	10	10
9	10	10
10	10	10
11	15	20
12	15	20
13	15	20
14	15	20
15	15	20
16	20	20

Is here a measure for? 
Using an IF condition to create these calculated columns seems not a good solution...

Thanks!

Julie

[bcdobbs · Accepted solution]

How about this:

Table TEST = 
ADDCOLUMNS (
    GENERATESERIES ( 1, 3000, 1 ),
    "Series 5", ( QUOTIENT( [Value] - 1, 5 ) + 1 ) * 5,
    "Series 10", ( QUOTIENT( [Value] - 1, 10 ) + 1 ) * 10
)

[ValtteriN · Accepted solution]

Hi,

Here is one way to do this:
5 series: 

Column 2 = FLOOR('Table'[Value]+5,5)

10 series:

Column = ROUNDUP('Table'[Value],-1)

I hope this helps and if it does consider accepting this as a solution and giving the post a thumbs up!

[bcdobbs · Accepted solution]

How about this:

Table TEST = 
ADDCOLUMNS (
    GENERATESERIES ( 1, 3000, 1 ),
    "Series 5", ( QUOTIENT( [Value] - 1, 5 ) + 1 ) * 5,
    "Series 10", ( QUOTIENT( [Value] - 1, 10 ) + 1 ) * 10
)