cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PietroFarias Regular Visitor
Regular Visitor

How to add columns to create hierarchy in query editor?

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?

Disire Result.jpg

 

 

 


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
3 REPLIES 3
v-fengyz-msft Frequent Visitor
Frequent Visitor

Re: How to add columns to create hierarchy in query editor?

@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 Regular Visitor
Regular Visitor

Re: How to add columns to create hierarchy in query editor?

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".

Highlighted
v-fengyz-msft Frequent Visitor
Frequent Visitor

Re: How to add columns to create hierarchy in query editor?

@PietroFarias

 

Glad hear you resolved the issue.

 

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

 

Regards,

Pirlo Zhang

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 311 members 3,206 guests
Please welcome our newest community members: