Forum Discussion

olgadir27's avatar
olgadir27
Frequent Visitor
6 years ago

Data structure

Hello! I have a table where a cost flow is going through the levels (1->2->3->4), with a few exceptions (1->2 & 1->3). Is there a way to subordinate the table to see the flow from 4 to the source? (...
Need Help
v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi olgadir27 ,

 

You may create calculated columns like DAX below.

 

Path Level1= PATH(Table1[Origin Level 1], Table1[Destination Level 1] )



Path Level2= PATH(Table1[Origin Level 2], Table1[Destination Level 2] )

 

For reference:

 

PATH, PATHLENGTH, PATHITEM, PATHITEMREVERSE, PATHCONTAINS – playing whith hierarchies (DAX – Power Pivot, Power BI)

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • olgadir27's avatar
    olgadir27
    Frequent Visitor
    6 years ago

    Thank you everyone for your time and suggestions!

     

    In PATH, I see I have duplicates both in Origin and Destination. My doubt is, can I omit them?