DAX CLONED ORDERS

[douglasgomez]

Hello, I need help creating a DAX for a table below to find out the source orders for cloned orders:

In the name column is the order number and in the Order_Cloned_From_c column is the order number that was cloned to generate the order in the name column.

There are orders that are clones of clones, so I need to know the number of each original. What was not cloned from another, generated manually.

What would be the DAX for this?

[amitchandak]

@douglasgomez , This seems like a parent-child hierarchy case. See if Path can help

https://www.youtube.com/watch?v=EzfLJFEKV8I

https://docs.microsoft.com/en-us/dax/understanding-functions-for-parent-child-hierarchies-in-dax

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

[Fowmy]

@douglasgomez 

Did not quite understand the logic here, if you could provide the expected results as well using the sample above, it would be clear enough.

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn