fbpx
Email: [email protected] Call Now! +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

{lowest_integer..highest_integer}

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.

ADD CUSTOM COLUMN

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.

CREATE TABLE WITH M CODE

CONCLUSION 

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