Handle Parent-Child hierarchy in Direct Query

DAX DAX Calculations
1

Hi,

Need some help or idea on how to handle Parent-Child hierarchy but with Direct Query.
As we cannot use PATH function, any workaround on this ?
Lets say I have table like this :

Capture
Capture884×289 7.85 KB

I’m sorry, I want to give the data in table format, but I don’t know how.

Thanks in advance

2

@Toni

3

Hi @Toni, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!