cancel
Showing results for
Did you mean:
Helper I

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

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

2 ACCEPTED SOLUTIONS
Super User

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

Ben Dobbs

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Super User

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!

Proud to be a Super User!

2 REPLIES 2
Super User

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!

Proud to be a Super User!

Super User

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

Ben Dobbs

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Announcements

#### Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

#### Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

#### What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.