Reply
hony
Frequent Visitor
Partially syndicated - Outbound

Row Hierarchy

Hi there,

 

I struggle hard to get this hierarchy flat. 

Each AR Elements belows to the latest PA above. I need the Disp1 of the according PA element at each child AR element. 

hony_0-1619515842631.png

 

Thanks a lot

hony

1 ACCEPTED SOLUTION
v-angzheng-msft
Community Support
Community Support

Syndicated - Outbound

Hi, @hony 

 

Try to create a custom column:

if [DE]="PA" then [#"NR-DISP1"] else null)

Then, to Use the fill down feature in power query

v-angzheng-msft_0-1619755783886.jpeg

v-angzheng-msft_1-1619755783887.jpeg

Result:

v-angzheng-msft_2-1619755783890.jpeg

Please refer to the attachment below for details

 

 

Is this the result you want? Hope this is useful to you

Please feel free to let me know If you have further questions

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-angzheng-msft
Community Support
Community Support

Syndicated - Outbound

Hi, @hony 

 

Try to create a custom column:

if [DE]="PA" then [#"NR-DISP1"] else null)

Then, to Use the fill down feature in power query

v-angzheng-msft_0-1619755783886.jpeg

v-angzheng-msft_1-1619755783887.jpeg

Result:

v-angzheng-msft_2-1619755783890.jpeg

Please refer to the attachment below for details

 

 

Is this the result you want? Hope this is useful to you

Please feel free to let me know If you have further questions

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

hony
Frequent Visitor

Syndicated - Outbound

hi there,

 

thanks for that fast answer - you got any idea how to do it in power query? I need the column there to move on. 😕

 

BEST

amitchandak
Super User
Super User

Syndicated - Outbound

@hony , Create a new column like

 

new column =
var _id = if([DE] ="AR", maxx(filter(Table, [Index] < earlier([index]) && [DE] ="PA"),[index]), [index])
return
maxx(filter(Table, [Index] =_id && [DE] ="PA"),[NR-DISP1])

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric Community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)