Easy way to get 15 free YouTube views, likes and subscribers

Get Free YouTube Subscribers, Views and Likes

Dynamically solve parent child hierarchies in Power BI and Power Query

Follow

The BIccountant

Parent child structures can dynamically be solved using a custom function in Power BI and Power Query.
See how to apply the function that you can find on my blog: https://www.thebiccountant.com/2017/0...

posted by guarerpf

Power BI & DAX: How to Flatten a Parent Child Hierarchy

Power BI & DAX: How to Flatten a Parent Child Hierarchy

How to FLATTEN your Hierarchies / Get Reporting Lines and Direct Reports // Power BI Guide in 2022

How to FLATTEN your Hierarchies / Get Reporting Lines and Direct Reports // Power BI Guide in 2022

Power BI Parent Child Chart of Accounts with M (Power Query)

Power BI Parent Child Chart of Accounts with M (Power Query)

Ragged Hierarchies in Analysis Services with Power BI and Excel

Ragged Hierarchies in Analysis Services with Power BI and Excel

DAX Fridays! #20: Parent and Child Functions Hierarchies

DAX Fridays! #20: Parent and Child Functions Hierarchies

Financial Statements with Power BI Part 1 P&L/BS

Financial Statements with Power BI Part 1 P&L/BS

How to create hierarchies in Power Query

How to create hierarchies in Power Query

Displaying only child values in parentchild Unplugged #46

Displaying only child values in parentchild Unplugged #46

Power BI: How to Create Hierarchical Data in Power BI Using DAX and Build Paginated Reports

Power BI: How to Create Hierarchical Data in Power BI Using DAX and Build Paginated Reports

PATH, PATHCONTAINS, PATHITEM, PATHITEMREVERSE, PATHLENGTH DAX Guide

PATH, PATHCONTAINS, PATHITEM, PATHITEMREVERSE, PATHLENGTH DAX Guide

Excel & Power BI Data Analysis Complete Class in One Video 365 MECS 04

Excel & Power BI Data Analysis Complete Class in One Video 365 MECS 04

How to Use List Generate to Make API calls in Power Query

How to Use List Generate to Make API calls in Power Query

NEVER GET AN ERROR when using PATH in DAX // Beginners Guide to Power BI in 2022

NEVER GET AN ERROR when using PATH in DAX // Beginners Guide to Power BI in 2022

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

Tree Visual with Parent Child Hierarchy in Power BI Visuals with Nags

Tree Visual with Parent Child Hierarchy in Power BI Visuals with Nags

Power BI Dynamic Hierarchies

Power BI Dynamic Hierarchies

Create Hierarchies in Power Query

Create Hierarchies in Power Query

Dealing with Incorrect Totals in Power BI

Dealing with Incorrect Totals in Power BI

Financial Modelling with Power BI

Financial Modelling with Power BI

VISUALISE ORG CHARTS + Path, PathLength, PathContains, PathItem DAX Functions to EXPLORE Hierarchy

VISUALISE ORG CHARTS + Path, PathLength, PathContains, PathItem DAX Functions to EXPLORE Hierarchy

Recommended

Don't Ever Say Musical Instruments Are Expensive!

Don't Ever Say Musical Instruments Are Expensive!

01:37

Raccoon Swimming School Opens Its Gates!

Raccoon Swimming School Opens Its Gates!

01:22

Take The Plane, They Said

Take The Plane, They Said

04:56

How To Make Your Marriage Life Exciting

How To Make Your Marriage Life Exciting

10:35

Singing - Best Way To Protect Your Car When Driving!

Singing - Best Way To Protect Your Car When Driving!

00:27

Play Drums Without Drums - Now It's Possible!

Play Drums Without Drums - Now It's Possible!

01:22

This Cat Will Never Be Counted Out!

This Cat Will Never Be Counted Out!

02:57

Vintage Farewell To The Year 2015!

Vintage Farewell To The Year 2015!

03:18