Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I have some issues with automating a tree hierarchy. I don’t know the final level of the hierarchy, so I need it fully automated. Given a set of data:
I found a lot of solutions where I can manually get the hierarchy in a column schema and use it with a DAX expression to prepare and use the date like this:
But I have now 2 open struggles: First of all I have currently 23 levels(!) and they will continue to grow. So this should be fully automated without the need of knowing the amount of levels before. And I need to display measures for every ID. Which leads me to my main questions:
Thank you in advance!
@HaSte , Have you already tried path , pathitem etc
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |