How to add same index column for every 10 rows [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed 4 months ago.

Improve this question

My csv file have one column with multiple rows.

I read that file in power bi desktop and try to display as paginated report .

The design I want to display is I like to show every 10 record as one page so I want to add same index for every 10 row and increase 1 and so on . So that I can group by that index and combine text .

Then I can show as one page in paginated report.

I like to know how can I add same index columns for every 10 row in power bi query?

kingsbane · Accepted Answer · 2025-07-25 09:40:08Z

0

let
    Source = Csv.Document(
        File.Contents("C:\path\to\your.csv"),
        [Delimiter=",", Columns=1, Encoding=1252, QuoteStyle=QuoteStyle.None]
    ),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Added Index" = Table.AddIndexColumn(#"Promoted Headers", "Index", 1, 1),
    #"Added Batch" = Table.AddColumn(
        #"Added Index",
        "Batch",
        each Number.IntegerDivide([Index] - 1, 10) + 1,
        Int64.Type
    ),
    #"Removed Index" = Table.RemoveColumns(#"Added Batch", {"Index"})
in
    #"Removed Index"

answered Jul 25 at 9:40

kingsbane

1792 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

DarkBee Jul 25 at 10:05

How does this address the issue? Please edit your answer and explain the changes you've made to solve the problem.

Jack jdeoel Jul 25 at 10:15

Thank for your answer. I have additional question. Let say this time have one more column which have value 1 and empty string. Becoz I don’t want to set fix 10 row.I want to set same index until next 1 value is found in each .

Sam Nseir Jul 25 at 10:50

After adding Index, add Table.AddColumn(#"Added Index", "GroupMe", each if [Test] = 1 then [Index] else null) then use the Fill Down under Transform. Then you can group on this column.

Collectives™ on Stack Overflow

How to add same index column for every 10 rows [closed]

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related