Forum Discussion
Attaching and completing data
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.
