Forum Discussion
Attaching and completing data
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
Hi,
Data downloaded from CSV
Calculated columns
Invoice number
Invoice content
Invoice date
Payment date
Application number
Year
Month
Number of days until payment
1/2/2024
aaaaaa
125
2024
2
50
10/8/2024
bbbbb
504
2024
8
13
150/09/2024
cccccc
106
2024
9
25
I want to attach an excel file and when I do it, the calculation columns are empty
Calculated columns
Invoice number
Invoice content
Invoice date
Payment date
Application number
Year
Month
Number of days until payment
1/2/2023
aaaaaa
130
1/8/2023
bbbbb
411
15/09/2023
cccccc
100
2.
I have grouped data and I want to complete the application number column
Invoice number
Amount
Invoice content
Application number
Number
1/2/2024
50
aa
125
1
1/2/2024
100
bb
null
2
1/2/2024
70
cc
null
3
10/8/2024
200
dd
null
1
10/8/2024
300
ee
504
2
10/8/2024
150
ff
null
3
1/2/2023
45
gg
null
1
1/2/2023
75
hh
null
2
1/2/2023
125
ii
106
3
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.
