How to solve hierarchy problems using the mask of each product ?

[Luizcarlospf]

I need to transform this data set into a hierarchical structure as in the example in the image

Can anybody help me ?

I used this data as an example: .csv

mask;hierarchy;level;Name;Value
1.2.33;1;1;Ativo;30
1.2.33;2;1;Passivo;50
1.2.33;1.1;2;Ativo Circulante;20
1.2.33;1.2;2;Ativo não Circulante;10
1.2.33;2.1;2;Passivo Circulante;20
1.2.33;2.2;2;Passivo não Circulante;30
1.2.33;1.1.10;3;Raw Material;20
1.2.33;2.2.10;3;Investment;10

[v-jayw-msft]

Hi @Luizcarlospf ，

Why you have blank row in "Ativo"? To what I understand according your description the total value for "Ativo" should be 30, did I missed any point?

Best Regards,

Jay

[Luizcarlospf]

I'm sorry, I ended up making a mistake in the example design. But your need to arrive in a hierarchy like this image using only one column with the "path". From what I have studied, the problem is in having identical "paths".

[Luizcarlospf · Accepted solution]

https://radacad.com/parsing-organizational-hierarchy-or-chart-of-accounts-in-power-bi-with-parent-ch...

I tried to follow that example(Link), but apparently there is no way, because you need to have the "names" keys.

I need to somehow create new columns (Levels) to replace the integer with the string (Name column)