Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have this situation in my file, where I have columns for each layer of the hierarchy, and I would like to create a 'normal' hierarchy with 2 columns (father and son) to use. I tried to append tables but I seem to miss the point in every function I try. Does anyone have any idea?
Please add an example of your expected results in two columns, based on the table you present in your question.
Read about the PATH functions, ragged hierarchies, and ISINSCOPE.