Attaching and completing data

Question

Cześć mam dwa pytaniaMam&nbsp;&nbsp; dane&nbsp; przekształcone przez formuły w PQ&nbsp; 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&nbsp; 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 · Answer

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

ola95 · Answer

Hi,Data downloaded from CSVCalculated columnsInvoice numberInvoice contentInvoice datePayment dateApplication numberYearMonthNumber of days until payment1/2/2024aaaaaa&nbsp;&nbsp;125202425010/8/2024bbbbb&nbsp;&nbsp;5042024813150/09/2024cccccc&nbsp;&nbsp;1062024925&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I want to attach an excel file and when I do it, the calculation columns are empty&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Calculated columnsInvoice numberInvoice contentInvoice datePayment dateApplication numberYearMonthNumber of days until payment1/2/2023aaaaaa&nbsp;&nbsp;130&nbsp;&nbsp;&nbsp;1/8/2023bbbbb&nbsp;&nbsp;411&nbsp;&nbsp;&nbsp;15/09/2023cccccc&nbsp;&nbsp;100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I have grouped data and &nbsp;I want to complete the application number column&nbsp;&nbsp;&nbsp;Invoice numberAmountInvoice contentApplication numberNumber&nbsp;&nbsp;&nbsp;1/2/202450aa1251&nbsp;&nbsp;&nbsp;1/2/2024100bbnull2&nbsp;&nbsp;&nbsp;1/2/202470ccnull3&nbsp;&nbsp;&nbsp;10/8/2024200ddnull1&nbsp;&nbsp;&nbsp;10/8/2024300ee5042&nbsp;&nbsp;&nbsp;10/8/2024150ffnull3&nbsp;&nbsp;&nbsp;1/2/202345ggnull1&nbsp;&nbsp;&nbsp;1/2/202375hhnull2&nbsp;&nbsp;&nbsp;1/2/2023125ii1063&nbsp;&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;Ola95&nbsp;,
&nbsp;
For question 1, you could&nbsp;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
&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.
&nbsp;
&nbsp;

olapol95 · Answer

Hi,&nbsp;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.&nbsp;Finally, I did this by merging with a tabele whit unigu data.&nbsp; Thank you.&nbsp;

Forum Discussion

Attaching and completing data

4 Replies

Related content

Grouping Data - Sample Attached

store data from email attachment

Refresh completed with warnings

Unable to load Azure log analytics data completely to Power BI

Creating Fabric Eventstream via API: How to complete the KQL Data Connection configuration?

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