Forum Discussion
Lucian
Responsive Resident
Responsive ResidentDynamic P&L Report from NAV Account Schedule
Hello, I need to create an P&L Report defined into Navision's Account Schedule that look like this: I have searched a lot of resources, and one is close enough to what I need, and I wou...
Hi Lucian
you can use my function to recursively solve this from here: https://www.thebiccountant.com/2017/02/14/dynamically-flatten-parent-child-hierarchies-in-dax-and-powerbi/
So first create a list of all items from the current row with my NAV-function that you've already found, expand and then use the above function to determine the levels / retrieve all parents.
ImkeF
Community Champion
Community ChampionHi Lucian
you can use my function to recursively solve this from here: https://www.thebiccountant.com/2017/02/14/dynamically-flatten-parent-child-hierarchies-in-dax-and-powerbi/
So first create a list of all items from the current row with my NAV-function that you've already found, expand and then use the above function to determine the levels / retrieve all parents.
