Skip to main content

Power BI

Needs Votes

Add INDENT.LEVEL in the Query Editor

Vote (15) Share
salosteysv's profile image

salosteysv on 28 Dec 2016 09:58:07

IF in the Excel cells we have data-tree like different columns:
City |
| London
| Paris
| New York

THEN this data in a Power Query and Query Editor, will be shown correctly.

But if we have ONE column with indent of the data levels (for example in Excel), like this:
city
London
Paris
New York

We will have a problems with data preparation. Because in Queries we will see only ONE column without indent levels :(
city
London
Paris
New York

I solved this problem with VBA with the command that evaluated Indent.Level in the cell. But VBA is not good way when we have a great tool Power Query or Query Editor.

Let's do this! Please, add indent.level to the inset "Transform".
Thank!