I do want to create a hierarchy - but not really the so called "hierarchy" in the DAX view. I mean an organizational hierarchy with different levels of aggregation. That's how my input data look like:
I basically want an output table like this (down to level 4):
I tried with pivoting, but for the 4th level, ist leaves levels 1 and 2 blank, which I dont want.
Thank you guys.
Did amitchandak 's suggestions help with your scenario? if that is the case, you can consider Kudo or accept his suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
@t_guet01 , Have you checked path functions, can not help ?
Proud to be a Super User!
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!