topic Re: Hierarchy start-up. Help!! in DAX Commands and Tips

Hierarchy start-up. Help!!

Anonymous — Thu, 15 Sep 2022 08:45:39 GMT

Hi,

I want to construct a hierarchy and have been told that I proabably only need two columns.

The columns I have is:

Stock Item Code (from 'Stock item master table'), and

Paren Stock Item (from 'Work order BOM' table).

As you see, the columns are from two different tables.

Can I construct a hierarchy anyway or?

I have read some posts on hierarchies in Power BI and found that many uses the 'PATH' function. When I try that function it tells me that I cannot use columns from two different tables.

Any ideas, trips or tricks on how I can get this started properly?

Many thanks!!

Re: Hierarchy start-up. Help!!

daXtreme — Thu, 15 Sep 2022 12:14:06 GMT

Hi Anonymous

Hierarchies can't be created from columns in different tables. That's about it. You have to bring the columns into one table. There are many ways to do it. You can bring a column to one of the original tables or you can create a completely new table with just the columns you need and then join the table to others (for it to make sense, of course).

On the other hand, the PATH* functions are used if you have a parent-child hierarchy in a table. Since PBI does not handle this natively, you have to flattten the hierarchy. That's what the functions are for. But it does not look like you have a parent-child hierarchy.

Parent-child hierarchies: Parent-child hierarchies – DAX Patterns

Hierarchies: Hierarchies – DAX Patterns

Re: Hierarchy start-up. Help!!

Anonymous — Thu, 15 Sep 2022 12:39:04 GMT

daXtreme

Thanks for your reply, I'm quite new to Power BI. Ok, then it was as I suspected.
I think the easiest approach for me would be to create a completely new table with those two columns.
How do I do that?

Something tells me that I first need to go to 'Transform Data'?

Ok, what do you mean by flatten the hierarchy?

With kind regards.

Re: Hierarchy start-up. Help!!

daXtreme — Thu, 15 Sep 2022 15:02:18 GMT

Parent-child hierarchies: Parent-child hierarchies – DAX Patterns

Hierarchies: Hierarchies – DAX Patterns