admin管理员组

文章数量:1395159

I want to replace the null values in my table with data from the "parent" record. Please see the example image from the Power BI Power Query editor.

Example of expectation

I've tried creating duplicates of the tables then merging, grouping and appending with no success, this is very frustrating.

I want to replace the null values in my table with data from the "parent" record. Please see the example image from the Power BI Power Query editor.

Example of expectation

I've tried creating duplicates of the tables then merging, grouping and appending with no success, this is very frustrating.

Share Improve this question asked Mar 12 at 20:55 Curtis GlardonCurtis Glardon 31 bronze badge 0
Add a comment  | 

2 Answers 2

Reset to default 0

Once it is sorted in the correct order, you can use Fill Down.

you can try to select the column and fill down data

本文标签: powerbiPower BI copy quotparentquot row data into quotchildquot rowsStack Overflow