Adding total sum previous year in a column

[Luca2020]

Hi, 

I've the following table "PRIMANOTA RIGHE"

 

The table shows the accounting journals of several companies and several years. To obtain the monthly balance sheet I created the following measure that returns the cumulative sum from the beginning of the year for each account:

IMP_SP = CALCULATE(CALCULATE(TOTALYTD(SUM('PRIMANOTA RIGHE'[Value])*-1; 'DATE'[Date].[Date]); FILTER('PRIMANOTA RIGHE'; NOT 'PRIMANOTA RIGHE'[Registration] IN {"CHPA"}))).

For example, the Trade Receivable for the PANT society are 220 (200 +20) in january 2020, in february they become 250 (220 +30)...

At the end of each year the accounting officer makes the closing entries (registration = CHPA) that reset all accounts to zero (for this reason I excluded the row that have registration = CHPA in the measure). Then at the beginning of the year the accounting officer makes the opening registrations to return the correct value (for example, the sum of the remaining trade receivables in 2019 amounts to 200 € as reported in the opening registration = APPA). The problem is that in reality the reopening is made around March or April, so until then the measure for the new year is missing the remaining amount from the previous year: 

The measure is incorrect until this registration is made: 

ACCOUNT             TYPE     REGISTRATION        DATE               VALUE
Trade Receivable     P                APPA           01/01/2021              30

How can I solve this problem? The correct measure formula requires to add the total sum previous year for each account (trade receivable is just one of many), if in the current year the registration APPA is missing. 

Thanks, 

Luca

[amitchandak]

@Luca2020 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Luca2020]

Hi, here is the link to the pbix file

https://drive.google.com/file/d/1b37-MQLZnLwujMS__d1GvKsyKt9bE_92/view?usp=sharing