Adding Data to an existing worksheet

[Anonymous]

I would like to add weekly data to a worksheet, to have accumulating data, how do I do that in Power BI?

[amitchandak]

@Anonymous , we do not know your data structure, try  like

Last week value = Maxx(FILTER('Table','Table'[week]<EARLIER('Table'[week])),lastnonblankvalue('Table'[week],sum('Table'[amount])))

Can you share sample data and sample output in table format?

[Anonymous]

Good morning,

I am very very new to PowerBI......I have watch multiple beginner tutorials and still very confused on how this program works.

My file has 47 columns and each week we have approx 35k rows....there is a lot of data - for that reason I am attempting to use PowerBI due to the hugh files in excel.....

For example, in my excel file, if June 4th had 35K rows (with the 47 columns) on June 11th, I would add another 35K rows (depending on how many transactions we had that week) and on June 18th I would add another 35K row (again according to how many transactions we had that week), so on and so forth.

I tried to add a sample file but do not not how to get the url (?)

As I mentioned above, I have watch several beginner tutorials and still completely lost on how to use this program.  Can you recommend a very, very basic tutorial?  I would only be using Excel files to upload/import.  What is the difference between upload and import?

[v-alq-msft]

Hi, @Anonymous 

You may click 'Refresh' button to update data weekly. Then you can aggregate data by week ang try what is suggested by @ryan_mayu . About the import and Direct Query mode, please refer to the document .

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

@Anonymous 

you can create a column

Column = SUMX(FILTER('Table','Table'[week]<=EARLIER('Table'[week])),'Table'[amount])

or you can create a measure

Measure = 
VAR  _week=SELECTEDVALUE('Table'[week])
return SUMX(FILTER(all('Table'),'Table'[week]<=_week),'Table'[amount])

[Anonymous]

My file has 47 columns.  Each week approx 35K transactions. 

I don't believe either suggestion would work.....I need to add approx 35K rows with 47 columns each week.

Any other suggestions?