Hi. I was using power query for finding all paginations but for some pages "add table using examples" doesn't work. Somehow I can extract number of reviews. Since every page has 100 comments I can guess how many pages would be. I need to create new rows in another table based on total comments devided by 100.

let Source = Excel.CurrentWorkbook(){[Name="Table5"]}[Content], pages = Table.AddColumn( Source, "Page", (x) => ( (team) => List.Transform( {1..Number.RoundUp(x[Reviews] / 100)}, (w) => Text.Format( "/teams/#{0}/comments/#{1}", {team, w} ) ) )(Text.Lower(Text.AfterDelimiter(x[Teams], " "))) ), xpand = Table.ExpandListColumn(pages, "Page")[[Teams], [Page]] in xpand

Create new rows based on number | Microsoft Fabric Community

Forum Discussion

Related content

Creating groups based on numbers

Creating a measure based on the number of Fridays in a month

Creating Index base 100 charts

Need help creating week number

Creating ICMs via Activator