Forum Discussion
Solved
Dataflow : recreating a hierarchy from self referencing table
Hi I'm setting up a new dataviz project for my company and I have a use case that I want to submit to this very active and great community 🙂 Context : all our data are stored in a postgre db...
The DAX functions are created specifically for this purpose, for me I would stick with that.
You could replicate this in your dataflow, or even in your warehouse by creating a flattened hierarchy. If your hierarchy will have the same amount of levels it would make sense to do it at warehouse and store as a table for the sake of using in multiple report solutions.
Thanks for sharing the link !