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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
83 | |
66 | |
61 | |
59 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |