How to add columns to create hierarchy in query editor?

[PietroFarias]

Guys, I want to find a more practical way to create columns where I will create the hierarchies in DAX. I have performed several redundant procedures in the Query Editor until the query stays as I want. But, I believe, there is some much more practical way. Can you show me?

These are the data I used in the example.

CÓD. CTA	G1	G2	G3	G4	G5	NOME DA CONTA	COD CONTA
1	1					ATIVO	1
2	1	1				CIRCULANTE	1.1
3	1	1	01			DISPONIVEL	1.1.01
101	1	1	01	01		CAIXA	1.1.01.01
10101	1	1	01	01	0001	Caixa	1.1.01.01.0001

[v-fengyz-msft]

@PietroFarias

It's hard to find the relationship between source and your desired result.

So, is there any logic between them? That's helpful.

Regards,

Pirlo Zhang 

[PietroFarias]

In fact what happened was the case of EXCESS work. hahaha .. The solution was always with me and was breaking the head. I went to sleep and when I woke up I saw the problem. My source was already what I needed, and did not need the "desired result".

[v-fengyz-msft]

@PietroFarias

Glad hear you resolved the issue.

If you have any questions, please feel free to ask.

Regards,

Pirlo Zhang