Sum of data with accumulated

[amartinezTower]

Good community,

I have the sum of some data displayed monthly.

Total Data - SUM(TH_SegProduccion_Golpes[TotalDest])

I have another measure to see the same data accumulated in 6 months.

Total Data Acum6m

VAR AcumuladoDatos=

CALCULATE([Total Datos],DATESINPERIOD(TD_Calendario[Fecha],MAX(TD_Calendario[Fecha]),-6,MONTH))

RETURN

IF ([Total Datos]<>BLANK(),AcumuladoDatos)

When I show the data in the table it shows me the cumulative total since the last date

But I want you to sum up the total of the detours:

Total= 1.352.904 + 1.305.285 + 1.232.726 + 920.541 + 824.461 + 811.195 + 852.989 + 878.178

Can someone help me? Thank you in advance

[AlB · Accepted solution]

Hi @amartinezTower 

Try  this new measure based on the one you already have:

Total Data Acum6m TOT =
SUMX ( DISTINCT ( TD_Calendario[Year-Month] ), [Total Data Acum6m] )

where  TD_Calendario[Year-Month]  is the field in the columns of your matrix visual. If you also have fields on the rows, you'll have to use SUMMARIZE( ) instead of distinct to include them  

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers