Power BITutorials

How to Create A Sequential List Using Power Query

1 Mins read

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-

To get in-depth knowledge about Power Query and its functions, check our latest high rated Power Query Course and become a pro in Power Query & it’s functioning.

Data Analytics Tricks in Power BI – Guidebook

You too can analyze data like a Data Scientist. No coding needed. No statistics needed.

Analyze & Visualize data using Power BI. (23 tricks in one book)

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.

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

Data Analytics Tricks in Power BI – Guidebook

You too can analyze data like a Data Scientist. No coding needed. No statistics needed.

Analyze & Visualize data using Power BI. (23 tricks in one book)

Related posts
AlteryxTutorials

Alteryx Hotkeys - Alteryx Keyboard Shortcuts

2 Mins read
Top 50+ Alteryx Shortcuts for Windows. Alteryx is popularly known as a Self-Service Analytics tool. Business users can build their data workflows…
AlteryxTutorials

Step By Step Guide to Learn Alteryx

6 Mins read
Alteryx Learning Path: The growth in technology has resulted in growth in understanding. In today’s world, humans – fellow businessmen know the…
Excel VBA CodeTutorials

VBA Code to Clean the Date Format

1 Mins read
When it is useful? Most of the time the most annoying problem is when the data is taken from ERP or other…

Leave a Reply

Your email address will not be published.