Cumulated (Balance Sheet) amounts based on transactional data

[AlexTaskar]

Hi Everybody,
I'm new to Power BI/DAX programming.
I have 3 years of transactional data (from my ERP system) - each line shows Date, AccountNumber, Dollar Amount ... . The data is relatively small - ~50,000 lines.
For Balance Sheet Accounts I want to calculate Cumulated Balances to be presented in PivotTable.
I use Power Pivot / Excel 2016.
Any help/ideas will be appreciated.

Thank you,
Alex

 

[akice]

Model design? dedicated calendar table? table names? Column names? relationships?

Sorry, but you simply haven't provided enough information to begin to help.

 

[Comfy]

Here's a very simple example:

http://s000.tinyupload.com/?file_id=92583907381867188555