Please tell me how to conditionally add a "row" in Power Query Editor.

[Tome_05]

I am always grateful for your help.

If anyone knows how to do it please let me know.
Currently, I have data like the attached image.
What I want to do is if the Value is 2, I would like to add one more data to the row with the same "ID", "Status", and "Value" data.
If Value is 4, add the remaining 3.
If Value is 8, add the remaining 7.
I would like to add a row with an upper limit like this, but if anyone knows how to do it, please let me know.

thank you.

[ryan_mayu · Accepted solution]

@Tome_05 

here is a workaround for you

create a new column 

=Text.Repeat(",",[value]-1)

then split olumn to rows

pls see the attachment below

[v-weiyan1-msft · Accepted solution]

Hi @Tome_05 ,

@ryan_mayu nice method! Thank you, for your helpful and quick response.
And you can also consider the following method.
1.Use the following code to add custom column in the Power Query Editor.

Table.Repeat(#table({"ID", "Status", "value"}, {{[ID], [Status], [value]}}), [value])

2.Expand the new custom column.

3.Then you can remove other temporary columns that created during the process.

Result is as below.

Is this the result you expect?
Please correct me if I misunderstood your needs.

Best Regards,
Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu · Accepted solution]

@Tome_05 

here is a workaround for you

create a new column 

=Text.Repeat(",",[value]-1)

then split olumn to rows

pls see the attachment below

[aj1973]

Hi @Tome_05 

Power BI is a read only SaaS, you can't add rows to its semantic model.