Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hierarchy start-up. Help!!

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 (...
daXtreme's avatar
daXtreme
Icon for Solution Sage rankSolution Sage
4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.