Forum Discussion

J_o_n_a_s's avatar
J_o_n_a_s
Helper I
5 years ago
Solved

Hierarchy Question?

Hi all,   I am not sure if this falls under hierarchies, but I didn't manage to solve this that way.    So I have this table:   Issue Name of Parent Issue Hours A-1   1 A-2   2 ...
Need Help
  • mhossain's avatar
    mhossain
    5 years ago

    J_o_n_a_s 

     

    You can create a mapping table like below and create relationship with your table, and then below mapping table will work like Level1 and Level2. Hope this helps.

     

    Issue Name of Parent Issue
    A-1 A-1
    A-2 A-2
    B-1 B-1
    B-2 B-2
    B-3 B-3
    B-22 B-2
    B-33 B-3
    C-1 C-1
    D-1 D-1
    E-1 E-1
Anand24's avatar
Anand24
Super User
5 years ago

Hi J_o_n_a_s ,

 

You can simple create a new column and use that.

DAX of new column:

New Issue = IF('Table'[Name of Parent Issue]=BLANK(),'Table'[Issue],'Table'[Name of Parent Issue])

 

Image Reference:

 

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!