Sum of monthly accumulated

[amartinezTower]

Good

I have a formula that sums up the accumulated data for one semester.

Total satos Acum6m =

VAR AcumuladoDatos=

CALCULATE([Total datos],DATESINPERIOD(TD_Calendario[Fecha],LASTDATE(TD_Calendario[Fecha]),-6,MONTH))

RETURN

IF ([Total Blows]<>BLANK(),Accumulated)

The problem is that the data appears correctly for months, but you needed the sum of the row to be those accumulated monthly. I actually get the same data as the last month shown in the table.

I understand why you're doing this, and I know I have to use another command, but I can't solve it.

I'd appreciate any help.

A greeting

[amartinezTower]

In the end I solved the problem with:

Total Data Acum6m TOT=

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

Thank you so much for all your help

[v-stephen-msft]

Hi @amartinezTower ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,
Stephen Tao

[v-stephen-msft · Accepted solution]

Hi @amartinezTower ,

You may try to create a measure to replace the original one.

New Total satos Acum6m=

IF(HASONEVALUE('TABLE'[MONTH]),[Total satos Acum6m],CALCULATE(SUM([Total datos]),ALL('TABLE')))

The HASONEVALUE is to perform a calculation in the row of the matrix to get the result1, and perform another calculation in the Total row to get the result2.

The word in your picture is in Spanish. I might misunderstand something wrong, please forgive me.

Reference: https://docs.microsoft.com/en-us/dax/hasonevalue-function-dax

Best Regards,

Stephen Tao

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

[amitchandak]

@amartinezTower , if you want to reset accumulative monthly. You need to use

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))

If you selected accumulative 

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[date])))

[amartinezTower]

I don't understand the answer.

I have data accumulated per semester (6 months), but in the total of this data I want the sum. I currently have the same calculation as tenfo per month column

[amartinezTower]

Debo haberme explicado mal. Te adjunto dos imagenes para entender el problema.

El total del acumulado me da 841.220, pero yo quiero la suma de los acumulados mostrados 8.178.279