Need Help? Chat with us
[email protected] +1 203-349-9909 / +91-8080042523

How to Create A Sequential List Using Power Query

The Power Query M language allows you to create a list containing a sequence of numbers or characters very easily. This is possible when you are defining lists by using expressions in the format-

Create A Sequential List With Power Query


Let us take an example to understand this feature.

Step 1: Add Custom Column

You can write an M query in Power Query Editor for creating a list of integers, list of characters and list of Unicode values. After you load the data in Power Query, you can link it to the list or table created using M query. To write the M query you can use the Advanced Editor or Custom column as shown below.


Step 2: Write M code

Write the M code we have created a simple table with three columns and three rows using the below-given formula-

#table({“A”..”C”}, {{1..3}, {7..9}, {11..13}})

The output of this formula is shown below.



This is how you can control, shape and modify your data table using Power Query Editor features in Power BI.

You can learn more : 

Leave a Reply