How to sum values of a matrix in a new column

[alexobip]

I have a table ‘Invoices’ which includes the [Date] of invoice (ex. 26/3/2022), the [Net Value] and I have created another two fields with the [Month] and the [Year] that I extract them from the invoice date. I have created the following matrix using:

The matrix is as shown in picture below.

I would like to use another column for each year that will show the sum of all months until that moment like the xls table bellow. The Sum column simply adds the Net Values of each month.

Is there any way to do so?

[Anonymous · Accepted solution]

Hi @alexobip ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data. 

(2) We can create  a measure. 

Sum = CALCULATE(SUM(Invoices[Net Value]),Invoices[Month]<=SELECTEDVALUE(Invoices[Month]))

(3) Then the result is as follows.

Best Regards,

Neeko Tang

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

[Shaurya]

Hi @alexobip,

You can use:

Cumulative = CALCULATE(SUM('Table'[Net Value]),FILTER(ALL('Table'),MONTH('Table'[Invoice Date])<MAX(MONTH('Table'[Invoice Date]))))

Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI