So I'd like the table below: DayValue1020.53141.552 I can generate two different tables but can't bring them together, I'm guessing this is pretty simple can someone please help? Generates a table with Value GENERATESERIES ( 0, 2, 0.5 ) Generates a table with DayGENERATESERIES ( 1, 5, 1 ) ThanksMark

BlueSky in power query , do the following: - add a blank query - click advanced editor and paste following code let #"Source" = Table.FromList({1..5}, Splitter.SplitByNothing(),{"index"},null, ExtraValues.Error), #"Added Index" = Table.AddIndexColumn(#"Source", "Factor", 0,0.5), #"Changed Type" = Table.TransformColumnTypes(#"Added Index",{{"index", Int64.Type}}) in #"Changed Type" I would 💖 Kudos 🙂 if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Generate a table with incremental values | Microsoft Fabric Community

Forum Discussion

Related content

Increment Refresh

Incremental refresh

Incremental Refresh

Generating Missing Data

SUMMARIZE, VALUES, and other table generation/manipuation with field parameters