Attaching and completing data

[Ola95]

Cześć mam dwa pytania

• Mam   dane  przekształcone przez formuły w PQ  pobrane z plików CSV, teraz muszę dołączyć tabelę z pliku ecxel, a po dołączeniu przekształcenia do nowych danych nie są kopiowane? Dane w pliku Excel mają te same kolumny i te same formaty. Co powinienem zrobić?

Mam jedną tabelę danych pogrupowanych według kategorii. Każdy  element danej kategorii ma indywidualny numer, tj. dla każdej kategorii numeracja zaczyna się od 1. Jedna kolumna ma niekompletne dane, chcę ją uzupełnić tak, aby uzupełnienie kończyło się ostatnim numerem danej kategorii.

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

[Ola95]

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

[Anonymous]

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.

[OlaPol95]

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.