Forum Discussion
Attaching and completing data
Hi Ola95 ,
For question 1, you could re-add columns after appending.
For question 2, you could use the "Group By" feature to group your data by the category column and add index column within each group. Use the "Fill Down" feature to fill in the incomplete data in the column based on the index.
Create Row Number for Each Group in Power BI using Power Query - RADACAD
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thank you, but I don't think I can use the fill down function, because after grouping the data, the application number is in different positions (first, third, sometimes fifth line of a given group) and the fill down function will enter the application number not from this group, because it fills in the data to the first one. non-empty. Finally, I did this by merging with a tabele whit unigu data. Thank you.