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

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### 2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors