topic Re: Acumulated production in DAX Commands and Tips

Acumulated production

OscarSuarez10 — Mon, 21 Oct 2019 15:01:11 GMT

Hello I want to calculate the acumulated production per year, task and ID, like in the following table, can you help me?

Anonymous — Mon, 21 Oct 2019 15:12:01 GMT

Hi,

modify below:

acumulated production =

CALCULATE (

sum("table name"[PRODUCTION]),

FILTER (

ALL ("TABLE NAME"[YEAR]),

"TABLE NAME"[YEAR] <= MAX ( "TABLE NAME"[YEAR] )

)

thanks

daniel

OscarSuarez10 — Mon, 21 Oct 2019 15:26:53 GMT

Hello Anonymous , thanks for your help, when I use this formula I get the same values, is not adding the previus one:

Anonymous — Mon, 21 Oct 2019 15:28:51 GMT

try the following expression:

var var_year = SELECTEDVALUE(table_name[YEAR])

return

CALCULATE(

sum(table_name[PRODUCTION]) ;

Hoja1[YEAR]<= var_year

)

I think it is enough for your requeriment, good luck ;)

OscarSuarez10 — Mon, 21 Oct 2019 16:04:26 GMT

Hello Anonymous I applied the formula in this way:

ACUMULATED PRODUCTION =

var var_year = SELECTEDVALUE('pruebas'[YEAR])

return

CALCULATE(

sum('pruebas'[PRODUCTION]) ;

'pruebas'[YEAR]<= var_year

)

But i got nothin in the column:

Doy you know what am i doing wrong?

Anonymous — Tue, 22 Oct 2019 08:55:34 GMT

I don't know what could happen. Check out the screenshot I attached, it may helps you: