Power BI Organizational Hierarchy or Chart of Accounts with Parent child functions in DAX

Power BI Organizational Hierarchy or Chart of Accounts with Parent child functions in DAX
Here is link to my blog post if you want to follow step by step:

[srinivaskrishnaswamy]

Great video on COA hierarchies. A pity that Microsoft Power BI does not have this as a first class feature of the tool. Hierarchies are everywhere and it should not be difficult to create a parent-child hierarchy. I love RADACAD videos. Keep up the good work !!

[nirmalyaroy]

Very useful.. Thanks for making our life easier.

[moc]

Excellent video, clearly explained and demonstrated. Thanks!

[olgamelo]

I was looking for this for quite some time and found your video . Great video. Thank you

[Arunadevaraj-lrxx]

Thank u so much yaarr. Exactly what I was looking for ...great video

[takumemmanuel]

Thanks very much. This video has greatly helped me overcome some major difficulties. Please, I will need to have one on dynamic row level security. Thanks.

[danielsiffredi]

This is exactly what I was looking for. Thanks man !

[avskadoo]

This technique is very use full in case you have one table with all information.
What if you want to filter Headcount and Termination tables at a same time with one slicer ?
Please guide

[vijayprakash]

Hello,

If you need to embed this report into an application where employeeID will be passed to this report and report should show both parents and child’s of the employee record that is opened in the application.

[vithtrinh]

Thank you so much, this is very helpful!

[KIAR]

perfect content, exactly what is needed. thank you :-)

[earth]

Thank you for the video. It was helpful for me.

[aleksanderstrommer]

how to use recursion and fill organzational path in on column like sanzhes/krebs/brown... ?

[naga]

Great video, how to get rid of the blanks that showed up in the slicer ?

[PedroCabraldaCamara]

That is such a great video!!!! Exactly what i was looking a lot!!!

[TrickMasterPC]

Retitle your video for search optimization. Suggest, Create Parent/Child Hierarchy in Power BI or Create Manager Employee Hierarchy in Power BI... you'll get way more views thinking about the way people search for this type of content.

[emilbek_isaev]

Thanks for video. What should be a parent id of a most top manager. Another words, what a parent of pyramid's top. I have an error issue with it.

[Aadhyagowdabc]

I have just employee column and manager column of over 4000 employees..now how to generate empkey and parent employee key?

[victorarayal]

Nice video! Thank you! Is there a easy way to get rid of the (blanks) that we see in the visual?

[Bharath_PBI]

Thank you. Can we do this in power query, with query folding, to get better data compression?