The 2nd Edition of #25daysofdaxfridays challenge is here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

Promote a row to a column in Power Query

In this video (a part of a Power Query challenge), I show you a practical example of how to promote rows to columns in Power Query.

The code

try AddIndex[Column1]{[Index]+1} otherwise null

Watch the tutorial:

To jump directly to the code check minute 5:04 of the video.

Promote a row to a column - Part 2: Power Query Challenge

Links to the mentioned resources

This video explains the technique in detail:

Get previous row in Power Query - EXPLAINED
Was this helpful?

Reader Interactions

Let us know your thoughts...

Table of Contents