Create new table with generated series

JeroenN 

Create a new table with the following code:

New Table = 
GENERATE(
    Table,
    GENERATESERIES(1,5)
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

Hi JeroenN 

This can be done in DAX as well, but I would recommend to do it in PQ. Place the following M code in a blank query to see the steps.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQwACGlWB0Y2wiJbYzENkFimyKxzZDY5khsCyS2JYJtaIDEBtobCwA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Unit Id" = _t]),

    #"Added Custom" = Table.AddColumn(Source, "Scenario", each List.Numbers(1,5)),
    #"Expanded Scenario" = Table.ExpandListColumn(#"Added Custom", "Scenario")
in
    #"Expanded Scenario"

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

Hi JeroenN 

Another solution in Power Query for good measure.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQwACGlWB0Y2wiJbYzENkFimyKxzZDY5khsCyS2JYJtaIDEBtobCwA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Unit Id" = _t]),
    #"Added Custom" = Table.AddColumn(Source, "Scenario", each {1..5}),
    #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Scenario")
in
    #"Expanded Custom"

Regards

Phil